List available printers?

Hot Topic

Office Word Macro - create file to a specific directory
Business Scorecard Manager - Deploy to Reporting Services (Report Server)
Assigning new series to chart
Restricting access to certain tables in Access DB - is this possible?
Does Share exist
Data access layer generating software approach
VBA Excel - Making MS Query from Excel using VBA
Copy an Excel File and Update some of it's cells
exporting & appending multiple excel files to MS access
Buddy program?

Microsoft ISV

Data pickup Issue
Architecture - what it is and what it will be
vlookup
MS Access 2007 Media Player Control Full Screen
Excessive Lag with VBA APP
MS Office document and image writer print driver
asp .Net 2.0 --> The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Windows media files have changes to Nero
String parsing in Express VB
Can you tell me why Int(1.4 * 100) = 139

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?

  • Patrick251

    This may be your solution

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

    Hope this helps.


  • Jim Hudson

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

  • Jim_B

    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.

  • kkos

    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.

  • Ted.

    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.
  • List available printers?
Answer this question