PDA

View Full Version : VBA to Check a network printer is online



cjmitton
11-19-2012, 03:10 PM
I'm trying to find some code for my word printing macro's.

I need to check to see if a printer is 'online' and if its not on-line then try another printer. I have the basic code but I don't know if there is a way in VBA I can check if a printer is online?

I'm running Word 2010 32bit edition on a Windows 7 Pro 32bit Desktop. With windows 2008 r2 server running my printer shares with a standard format for the share name of \\ server \ printer (without the spaces!)

Thanks