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 .
|Country:||Sao Tome and Principe|
|Published (Last):||10 March 2017|
|PDF File Size:||20.60 Mb|
|ePub File Size:||3.74 Mb|
|Price:||Free* [*Free Regsitration Required]|
We may share certain information about our users with our advertising and analytics partners. Changing the active printer in a macro Hello andy, You need to include the colon “: Once you find the printer name activeprinted it’s port you can change it using the method WBD posted.
Activeprinter in Word en Powerpoint.
Network Printer ‘ActivePrinter’ of object’_Application’ failed – Free Excel\VBA Help Forum
Thanks Paul, I would do that if I knew how to!! If this is your first visit, be sure to check out the Board FAQ by clicking the link above. I agreed to these rules. At startup Excel will set Application. Network Avtiveprinter Port reference normally will be NExx jiuk.
When they start tele commuting, then it’s gonna applicatuon really ugly –Paul It’s important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face And do that on all machines of all users?
You may have to register before you can post: Do I apppication the code line application. May 18th, Changing the active printer in a macro Hello andy, You will need a little more information to set the ActivePrinter. Resources saved on this page: Login or Sign Up. Excel on Windows Run the macro “ShowPrintersAndPorts”.
Register now while it’s still free!
How to set Excel’s ActivePrinter using VBA?
Thread Tools Show Printable Version. You could just set that if you know the name of the printer: Hello andy, You need to include the colon “: In particular there is a localization issue. Is there a line I can add to the macro to select the correct printer so I can JUST activate it without having to sidetrack?
Go into the printer properties, and Add Port, or Configure Port –Paul It’s important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face Click Here to join Tek-Tips and talk with other members!
Member List Calendar Forum Rules. So your activepeinter not such universal. Changing the active printer in a macro Alright, I tried the full string, and just the printer name, and the port.
Thank you Fran Bus. Last edited by Leith Ross; Sep cativeprinter, at Results 1 to 10 of Changing the active printer in a macro Probably it would be: Dialogs xlDialogPrinterSetup and ask the user to select the printer.
Share it with others Like this thread? The problem I typed?
Forums Blogs Articles Groups. Otherwise, it will try to print from the other connected printer. Changing the active printer in a macro. Recent comments cbd clinic products on Excel and XML: To start viewing messages, select the forum that you want applucation visit from the selection below.
VBA stuff Tagged With: Promoting, selling, recruiting, coursework and thesis posting is forbidden. I ran the macro just now, and it gave a completely different port.
Changing the active printer in a macro
The Tek-Tips staff will check this out and take appropriate action. How to get the port of a printer?
This will display a list of printers and faxes for the local computer. The time now is You need to know the printer’s name and the port it uses. I have a macro that I use to change activepriinter fill color of cells, hide and unhide columns, and print 1 copy of each worksheet in the file.
Add a new VBA Module to workbook and paste the code below into it. Please use [code] tags when posting code. ActivePrinter End Sub And this is the function: