Printing MSG
I’ve recorded a macro to print to the default printer and to another printer on the network.
I need to add something to MSG the user as to if the network printer is not installed, to add the network printer.
So the code would still print to the default printer but if the other printer is not installed, the message would request for the user to install printer listed in the code. How do I do this?
Hello Tortus,
Working with printers is not easy if the function doesn't exist. It usually invloves using scripting languages like VBS, WSH, or WMI or the Windows API. In this case I the API because it works Windows '95 through XP. This code hasn't been test on Vista. Copy this code into a Standard VBA Module. Call the macro IsPrinterInstalled to check if a printer is installed on the user's machine. You only need to use the name. The function returns true if the printer is installed, otherwise it will return false. Case is ignored.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks