Thread: Printer Listing
View Single Post
 
Old 04-30-2019, 07:32 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
No version of Excel supports a Printers property, but you can use WMI:

Code:
    Dim Printer As Object
    For Each Printer In GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2"). _
        ExecQuery("Select * from Win32_Printer")
    MsgBox Printer.Name
    Next
Reply With Quote