List available printers?

Hot Topic

How to copy pivot table RESULT from Access to Excel
iexplore.exe - Application Error
how to close a userform in workbooks.open method
Configuration Failed
wrong count of Records in Access.Form
Excel Macro to Capture Live Webcam Image?
WOW64
Map Point Control - How to add Hyperlink to a note in Map Point ?
Refer to Mail Merge Fields from Embedded Excel Chart
autocomplete

Microsoft ISV

Excel Chart: How to change chart data source formula when object "Series.Formula" is too short?
Using combobox in Excel
use inputbox to choose cells for plots in excel
Creating a Toolbar and a button that is linked to a macro
Sql SELECT query from VBA in Access
Access Security Warnings
VBA code to search and modify in Word
Error starting Live Communication 2005 Archiving
Library Reference issues.
Run Time Error 9 when Calling a Userform

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?

  • carjo

    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.

  • Manoj Bhardwaj

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

  • lbugnion

    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.

  • NT2

    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.

  • AndyPham

    This may be your solution

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

    Hope this helps.


  • List available printers?
Answer this question