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 .

Author: Yozshuzilkree Gujora
Country: Pacific Islands
Language: English (Spanish)
Genre: Career
Published (Last): 5 September 2010
Pages: 461
PDF File Size: 8.71 Mb
ePub File Size: 16.98 Mb
ISBN: 555-1-91227-381-3
Downloads: 42050
Price: Free* [*Free Regsitration Required]
Uploader: Mezikasa

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? •

Resources saved on this page: For additional details, refer to our Privacy Policy. Run the macro “ShowPrintersAndPorts”. Otherwise, it will try to print from the other connected printer.

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.

Network Printer Thanks shg Ozgrid is Not Associated With Microsoft. We process personal data about users of our site, through the use of cookies and other technologies, activprinter deliver our services, personalize advertising, and to analyze site activity.

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.