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: Zulkizil Vugar
Country: Reunion
Language: English (Spanish)
Genre: Education
Published (Last): 3 May 2018
Pages: 315
PDF File Size: 5.25 Mb
ePub File Size: 15.72 Mb
ISBN: 246-7-38991-171-3
Downloads: 28871
Price: Free* [*Free Regsitration Required]
Uploader: Mauzshura

That’s definitely another way, that should work, but its also important to take control of your network, while you still can.

May 18th, This is the code to test the function: Configure the printer ports on each machine to have the same configuration for the Win2PDF printer Just a thought –Paul It’s important in life to always strike a happy medium, applicatioh if you see someone with a crystal ball, and a smile on their face 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 activdprinter.

Configure the printer ports in Windows. Share it with others Like this thread? Activeprinter in Word en Powerpoint. Solved that my problem — added the line ThisWorkbook. Hello andy, You will need a little more information to set the ActivePrinter.


Please use [code] tags when posting code. Entia non sunt multiplicanda sine necessitate. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

Otherwise, it will try to print from the other connected printer.

Please post data in proper tables – I suggest this tool. ActivePrinter in the immediate window and got as reply: August 05, ‘ Authoer: Glad you have everything working now.

Changing the active printer in a macro There’s a property of the Application object called ActivePrinter.

Resources saved on this page: Returns and array of printer names and port numbers on the user’s computer. How to get the port of a printer? And do that on all machines of activeprinnter users? Hello I am having trouble printing a page to both a local printer which works fine and a network printer which does not work Both printers are installed on the Computers.

Replacing USB with that solved the issue. We may share certain information about our users with our advertising and analytics partners.

Printer property (Excel) | Microsoft Docs

Error in actveprinter It’s easy to join and it’s free. Changing the active printer in a macro The port used is USB ActivePrinter End Sub And this is the function: Leith Ross ‘ Summary: Changing the active printer in a macro.

Network Printer Thanks shg Print “No match” Else Application. Thanks very much for this! Register now while it’s still free!


Setting Printer and .PrintForm

The time now is You may have to register before you can post: Changing the activeprinrer printer in a macro Alright, I tried the full string, and just the printer name, and the port.

Forums Blogs Articles Groups. So your code not such universal. Posting Adtiveprinter Promoting, selling, recruiting, coursework and thesis posting is forbidden. All contents Copyright by MrExcel Publishing. I almost decided to hard code the string for the above mentioned languages when I realized that the solution is already there.

To start viewing messages, select the forum that you want to visit from the selection below. The problem I typed? This will display a list of printers and faxes for the local computer.

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

If this is your first visit, be sure to check out the Board FAQ by clicking the link above. Probably it would be: Once you find the printer name and it’s port you can change it using the method WBD posted.

Changing the active printer in a macro Hello andy, You will need a little more information to set the ActivePrinter. ActivePrinter ‘ do something with the temp printer Application.