I am trying to send the form to a printer other than the default printer using: Printer = “HP LaserJet Series PCL on LPT4:”. There’s a property of the Application object called ActivePrinter. You could just You will need a little more information to set the ActivePrinter. The Printer property needs to be changed in the registry code in order to print from a different printer other than the default printer. If we need to .
|Published (Last):||5 September 2010|
|PDF File Size:||8.71 Mb|
|ePub File Size:||16.98 Mb|
|Price:||Free* [*Free Regsitration Required]|
Solved that my problem — added the line ThisWorkbook.
Hello andy, You need to include the colon “: I expected that this would do it:. Thanks Paul, I would do that if I knew how to!! Results 1 to 10 of Changing the active printer in a macro Hello Andy, You’re welcome. activeeprinter
Close this window and log in. I expected that this would do it: Share it with others Like this thread?
Printer property (Excel) | Microsoft Docs
Login or Sign Up. This will display a list of printers and faxes for the local computer. Once you find the printer name and it’s port applicatino can change it using the method WBD posted. E-mail subscription to new posts?
Thanks for your help!
Changing the active printer in a macro Probably it would be: Leith Ross ‘ Summary: Recent comments cbd clinic products on Excel and XML: Just loop through the possible network numbers with an On Error resume next and error check Comments Lewis Metzger says: And do that on all machines of all users?
I could not find any difference with my pc, where there is no such problem. Thanks for the suggestion, it works ok on my pc, but unfortunately I am having a couple of problems. Thank you Fran Bus.
How to set Excel’s ActivePrinter using VBA? •
Excel not only wants to activeprinterr the printer name but also the port name of the printer, which can be something like Ne01, LPT1, Nul or any IP address. Does it need a particular library?
VBA Visual Basic for Applications (Microsoft) FAQ
I activepriinter a macro that I use to change the fill color of cells, hide and unhide columns, and print 1 copy of each worksheet in the file. Network Printer Does the Ne Changing the active printer in a macro Hello andy, You will need a little more information to set the ActivePrinter.
Please post data in proper tables – I suggest this tool. In particular there is a localization issue. Do I make the code line application.
How to get the port of a activeprijter However, I need to manually select the printer and close out of the ‘print’ screen before I activate it. I almost decided to hard code the string for the above mentioned languages when I realized that the solution is already there. If this is your first visit, be sure to check out the Board FAQ by clicking the link above.