List available printers?

Hot Topic

Macro to Delete Rows
ADO Recordsets
Outputting to a Listbox
MS Access pivot table problem, field list not available & can't drill down
Select with macro based on criteria
Refer to Mail Merge Fields from Embedded Excel Chart
"Bizzare" Sendkey Code in Excel
Refer to another module
Help with largest values and counts of those values.
Excel user form to select a favourite file

Microsoft ISV

Business Scorecard Manager to Sharepoint deployment
Creating Logon in MS Access
Programming Adobe Acrobat Reader 7.0
Using Proper function to Format Worksheet
Strange Outlook 2007 POP3 Behavior & Slowness
Copy text from textbox to clipboard?
OK Trying Again - A Simple Very Simple Routine
CDONTS
ADODB.Connection.Open fails (MS Access VBA)
FORMAT OF A VARIABLE USED IN VBA MACRO PROBLEM

List available printers?

Hello guys,

I am having a hard time to access a list of available printers. How do I do that I am trying to print mail merged labels. When I record the macro, it sets the activePrinter to a string. I wish to set that value using a drop down list GUI. Thank you.

Answer this question

List available printers?

  • pragati22

    OMG, it works. Thank you so much. You are my hero.

  • Luiz Américo

    Thanks for the reply. How do I do that in VB I don't know a thing about hardware access or device access in any language. Please let me know which library or object I can use to retrieve the information, thank you.

  • wannabguru

    I've been looking as well. The only thing I can find for you is that you can find what the active printer is under application, but that's not what you are looking for. If you have VB, you could write a little program that will return the printers for you and call it from VBA.

  • Misbah Ahmad

    Anyone All I need is a function that returns a list of available printers. I am unable to find it in VBA reference. Thank you.

  • aztec2_step

    This may be your solution

    http://word.mvps.org/FAQs/MacrosVBA/AvailablePrinters.htm

    Hope this helps.


  • List available printers?
Answer this question