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: Meztim Migar
Country: Ethiopia
Language: English (Spanish)
Genre: Business
Published (Last): 15 January 2007
Pages: 255
PDF File Size: 16.62 Mb
ePub File Size: 1.21 Mb
ISBN: 387-7-77510-984-3
Downloads: 52408
Price: Free* [*Free Regsitration Required]
Uploader: Jutaur

You may have to register before you can post: Member List Calendar Forum Rules. Otherwise, it will try to print from the other connected printer.

VBA Visual Basic for Applications (Microsoft) FAQ

ActivePrinter port name in Excel??? Your code is simply brilliant. Return to top of page. In case you haven’t guessed, I’m quite new to VBA! At startup Excel will set Application. Returns and array of printer names and port numbers on the user’s computer. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Network Printer Does the Ne Changing the active printer in a macro The port used is USB Network Printer Port reference normally will be NExx jiuk.

  CAT 315D L PDF

Exit Function Do Start: Changing the active printer in a macro Alright, I tried the full string, and just the printer name, and the port. Ozgrid is Not Associated With Microsoft. Hello Andy, You’re welcome.

I expected that this would do it: Last edited by shg ; May 18th,applkcation Results 1 to 10 of Do I need to define a variable first? All three errored me out. The codes that I have used are Code:. Leith Ross ‘ Summary: All times are GMT That’s definitely another way, that should work, but its also important to take control of your network, while you still can.

Thanks for your help! Thread Tools Show Printable Version. Register now while it’s still free! Litle bit modify your code. Dialogs xlDialogPrinterSetup and ask the user applicatoin select the printer. Run the macro “ShowPrintersAndPorts”. You could just set that if you know the name of the printer: Thanks very much for this!

Thanks for the suggestion, it works ok on my pc, but unfortunately I am having a couple of problems. Network Printer Thanks shg ActivePrinter ‘ do something with the temp printer Application. Add a new VBA Module to workbook and paste the code below into it. I have added them for you here; please be mindful in the future.

Entia non sunt multiplicanda sine necessitate. Excel not only wants to know the printer name but achiveprinter the port name of the printer, which can be something like Ne01, LPT1, Nul or any IP address. ActivePrinter to your default printer, in activeprintfr case usually a Laserjet. Solved that appliaction problem — added the line ThisWorkbook. And do that on all machines of all users? Thanks Paul, I would do that if I knew how to!!


So your code not such universal. Red Flag This Post Please let us know here why this post is inappropriate.

Any ideas how to make the applixation use the same NE port number on all three machines? I have 32 bit Windows API code that gets the device names and works well locally, but needs additional work for network printers.

[Application.]ActivePrinter [= setting] – Programming Excel with VBA and .NET [Book]

How to get the port of a printer? Please use [code] tags when posting code. 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.

Subscribe US Now