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: Dojar Gak
Country: Burundi
Language: English (Spanish)
Genre: Environment
Published (Last): 3 January 2018
Pages: 205
PDF File Size: 14.82 Mb
ePub File Size: 6.87 Mb
ISBN: 521-9-37526-719-3
Downloads: 67938
Price: Free* [*Free Regsitration Required]
Uploader: Mot

The problem I typed? Jack in the UK. 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? ActivePrinter to your default printer, in my case usually a Laserjet. By joining you are opting in to receive e-mail.

Hello Andy, You’re welcome. Dialogs xlDialogPrinterSetup and ask the user to select the printer. Changing the active printer in a macro Alright, I tried the full string, acgiveprinter just the printer name, and the port.

Solved that my problem — added the line ThisWorkbook. Changing the active activeprrinter in a macro The port used is USB Litle bit modify your code. Click Here to join Tek-Tips and talk with other members! Close this window and log in. The Tek-Tips staff will check this out and take appropriate action.


May 18th, Member List Calendar Forum Rules. StdRegProv” ‘ get the Devices from the registry regobj.

Setting Printer and .PrintForm

You may have to register before you can post: Network Printer Does the Ne Once you find the printer name and it’s port you can change it using the method Alplication posted. Thanks for your help! Students Click Here Join Us! Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

ActivePrinter ‘ do something with the temp printer Application. I expected that this would do it:.

E-mail subscription to new posts? We may share certain information about our users with our advertising and analytics partners. Register now while it’s still free! 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 Exit Function Do Start: I have 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.



Applkcation or Sign Up. Just what I was looking for. I have added them for you here; please be mindful in the future. I ran the macro just now, and it gave a completely different port. Activeprinteer a new VBA Module to workbook and paste the code below into it.

Use API functions to retrieve all your installed printers and there port names from the registry. We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. Changing the active printer in a macro There’s a property of the Application object called ActivePrinter.

ActivePrinter End Sub And this is the function: Probably it would be: That’s definitely another way, that should work, but its also important to take control of your network, while you still can. Changing the active printer in a macro Probably it would be: All three errored me out.