LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 284
Default Listing Printers in Excel

Copied below are lines from a generic script that should give you good
indicators on available properties providing info on printers. All
properties should be available on WinXP or Server2003, most properties
available on Win2k, WinME or systems where WMI has been downloaded.

For Each objItem In colItems
WScript.Echo "Attributes: " & objItem.Attributes
WScript.Echo "Availability: " & objItem.Availability
strAvailableJobSheets = Join(objItem.AvailableJobSheets, ",")
WScript.Echo "AvailableJobSheets: " & strAvailableJobSheets
WScript.Echo "AveragePagesPerMinute: " & objItem.AveragePagesPerMinute
strCapabilities = Join(objItem.Capabilities, ",")
WScript.Echo "Capabilities: " & strCapabilities
strCapabilityDescriptions = Join(objItem.CapabilityDescriptions, ",")
WScript.Echo "CapabilityDescriptions: " & strCapabilityDescriptions
WScript.Echo "Caption: " & objItem.Caption
strCharSetsSupported = Join(objItem.CharSetsSupported, ",")
WScript.Echo "CharSetsSupported: " & strCharSetsSupported
WScript.Echo "Comment: " & objItem.Comment
WScript.Echo "ConfigManagerErrorCode: " &
objItem.ConfigManagerErrorCode
WScript.Echo "ConfigManagerUserConfig: " &
objItem.ConfigManagerUserConfig
WScript.Echo "CreationClassName: " & objItem.CreationClassName
strCurrentCapabilities = Join(objItem.CurrentCapabilities, ",")
WScript.Echo "CurrentCapabilities: " & strCurrentCapabilities
WScript.Echo "CurrentCharSet: " & objItem.CurrentCharSet
WScript.Echo "CurrentLanguage: " & objItem.CurrentLanguage
WScript.Echo "CurrentMimeType: " & objItem.CurrentMimeType
WScript.Echo "CurrentNaturalLanguage: " &
objItem.CurrentNaturalLanguage
WScript.Echo "CurrentPaperType: " & objItem.CurrentPaperType
WScript.Echo "Default: " & objItem.Default
strDefaultCapabilities = Join(objItem.DefaultCapabilities, ",")
WScript.Echo "DefaultCapabilities: " & strDefaultCapabilities
WScript.Echo "DefaultCopies: " & objItem.DefaultCopies
WScript.Echo "DefaultLanguage: " & objItem.DefaultLanguage
WScript.Echo "DefaultMimeType: " & objItem.DefaultMimeType
WScript.Echo "DefaultNumberUp: " & objItem.DefaultNumberUp
WScript.Echo "DefaultPaperType: " & objItem.DefaultPaperType
WScript.Echo "DefaultPriority: " & objItem.DefaultPriority
WScript.Echo "Description: " & objItem.Description
WScript.Echo "DetectedErrorState: " & objItem.DetectedErrorState
WScript.Echo "DeviceID: " & objItem.DeviceID
WScript.Echo "Direct: " & objItem.Direct
WScript.Echo "DoCompleteFirst: " & objItem.DoCompleteFirst
WScript.Echo "DriverName: " & objItem.DriverName
WScript.Echo "EnableBIDI: " & objItem.EnableBIDI
WScript.Echo "EnableDevQueryPrint: " & objItem.EnableDevQueryPrint
WScript.Echo "ErrorCleared: " & objItem.ErrorCleared
WScript.Echo "ErrorDescription: " & objItem.ErrorDescription
strErrorInformation = Join(objItem.ErrorInformation, ",")
WScript.Echo "ErrorInformation: " & strErrorInformation
WScript.Echo "ExtendedDetectedErrorState: " &
objItem.ExtendedDetectedErrorState
WScript.Echo "ExtendedPrinterStatus: " & objItem.ExtendedPrinterStatus
WScript.Echo "Hidden: " & objItem.Hidden
WScript.Echo "HorizontalResolution: " & objItem.HorizontalResolution
WScript.Echo "InstallDate: " &
WMIDateStringToDate(objItem.InstallDate)
WScript.Echo "JobCountSinceLastReset: " &
objItem.JobCountSinceLastReset
WScript.Echo "KeepPrintedJobs: " & objItem.KeepPrintedJobs
strLanguagesSupported = Join(objItem.LanguagesSupported, ",")
WScript.Echo "LanguagesSupported: " & strLanguagesSupported
WScript.Echo "LastErrorCode: " & objItem.LastErrorCode
WScript.Echo "Local: " & objItem.Local
WScript.Echo "Location: " & objItem.Location
WScript.Echo "MarkingTechnology: " & objItem.MarkingTechnology
WScript.Echo "MaxCopies: " & objItem.MaxCopies
WScript.Echo "MaxNumberUp: " & objItem.MaxNumberUp
WScript.Echo "MaxSizeSupported: " & objItem.MaxSizeSupported
strMimeTypesSupported = Join(objItem.MimeTypesSupported, ",")
WScript.Echo "MimeTypesSupported: " & strMimeTypesSupported
WScript.Echo "Name: " & objItem.Name
strNaturalLanguagesSupported = Join(objItem.NaturalLanguagesSupported,
",")
WScript.Echo "NaturalLanguagesSupported: " &
strNaturalLanguagesSupported
WScript.Echo "Network: " & objItem.Network
strPaperSizesSupported = Join(objItem.PaperSizesSupported, ",")
WScript.Echo "PaperSizesSupported: " & strPaperSizesSupported
strPaperTypesAvailable = Join(objItem.PaperTypesAvailable, ",")
WScript.Echo "PaperTypesAvailable: " & strPaperTypesAvailable
WScript.Echo "Parameters: " & objItem.Parameters
WScript.Echo "PNPDeviceID: " & objItem.PNPDeviceID
WScript.Echo "PortName: " & objItem.PortName
strPowerManagementCapabilities =
Join(objItem.PowerManagementCapabilities, ",")
WScript.Echo "PowerManagementCapabilities: " &
strPowerManagementCapabilities
WScript.Echo "PowerManagementSupported: " &
objItem.PowerManagementSupported
strPrinterPaperNames = Join(objItem.PrinterPaperNames, ",")
WScript.Echo "PrinterPaperNames: " & strPrinterPaperNames
WScript.Echo "PrinterState: " & objItem.PrinterState
WScript.Echo "PrinterStatus: " & objItem.PrinterStatus
WScript.Echo "PrintJobDataType: " & objItem.PrintJobDataType
WScript.Echo "PrintProcessor: " & objItem.PrintProcessor
WScript.Echo "Priority: " & objItem.Priority
WScript.Echo "Published: " & objItem.Published
WScript.Echo "Queued: " & objItem.Queued
WScript.Echo "RawOnly: " & objItem.RawOnly
WScript.Echo "SeparatorFile: " & objItem.SeparatorFile
WScript.Echo "ServerName: " & objItem.ServerName
WScript.Echo "Shared: " & objItem.Shared
WScript.Echo "ShareName: " & objItem.ShareName
WScript.Echo "SpoolEnabled: " & objItem.SpoolEnabled
WScript.Echo "StartTime: " & WMIDateStringToDate(objItem.StartTime)
WScript.Echo "Status: " & objItem.Status
WScript.Echo "StatusInfo: " & objItem.StatusInfo
WScript.Echo "SystemCreationClassName: " &
objItem.SystemCreationClassName
WScript.Echo "SystemName: " & objItem.SystemName
WScript.Echo "TimeOfLastReset: " &
WMIDateStringToDate(objItem.TimeOfLastReset)
WScript.Echo "UntilTime: " & WMIDateStringToDate(objItem.UntilTime)
WScript.Echo "VerticalResolution: " & objItem.VerticalResolution
WScript.Echo "WorkOffline: " & objItem.WorkOffline
WScript.Echo
Next
Next

Steve

"RobC" wrote in message
...
Steve,

This is what I was looking for but hard to find info on.

Are there anyother properties other than Name and Default? i.e., Port?

The link on the next response was also good but very complex.

Thanks... Rob



"Steve Yandl" wrote in
:

Rob,

The Word MVPs have a discussion on using the Windows API he
http://word.mvps.org/FAQs/MacrosVBA/...lePrinters.htm

If you knew the users were all using WindowsXP you could use something
like this:

Sub PrinterList()
Dim R As Integer

R = 2
strComputer = "."

Cells(1, 1).Value = "Printer Name"
Cells(1, 2).Value = "Default"

Set objWMIService = GetObject _
("winmgmts:\\" & strComputer & "\root\cimv2")
Set colPrinters = objWMIService.ExecQuery _
("Select * From Win32_Printer")

For Each objPrinter In colPrinters
Cells(R, 1).Value = objPrinter.Name
Cells(R, 2).Value = objPrinter.Default
R = R + 1
Next

End Sub


Steve Yandl





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel spreadsheet prints differently on different printers Derek Overton Excel Discussion (Misc queries) 4 August 24th 09 06:16 PM
Printing EXCEL tables with sophisticated HP Printers such as the D VAUTOUR 110 Excel Discussion (Misc queries) 1 June 3rd 09 09:58 PM
Excel 2007 Margins Cut Off Printing to Non-Physical Printers CEK Excel Discussion (Misc queries) 0 March 13th 08 03:46 PM
Excel 2007, Vista - losing printers Alan Excel Discussion (Misc queries) 0 June 19th 07 04:55 PM
Excel cannot find printers coopercat Excel Discussion (Misc queries) 0 November 30th 05 05:17 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"