Recently I wanted to change Excel’s ActivePrinter using VBA. That isn’t as straightforward as I expected it to be. In particular there is a. There’s a property of the Application object called ActivePrinter. Add a new VBA Module to workbook and paste the code below into it. Is there a way of creating a list of Active Printers on a users computer for the user to select to be used in the PrintOut method i.e. I am bypassing.

Author: Kelkis Sashicage
Country: Honduras
Language: English (Spanish)
Genre: Travel
Published (Last): 5 November 2017
Pages: 52
PDF File Size: 9.49 Mb
ePub File Size: 19.99 Mb
ISBN: 234-3-79220-965-4
Downloads: 95584
Price: Free* [*Free Regsitration Required]
Uploader: Sakazahn

Forums Blogs Articles Groups. However, I need to manually select the printer and close out of the ‘print’ screen before I activate it. I could not find any difference with my pc, where there is activepriner such problem.

Do I make the code line application.

StdRegProv” ‘ get the Devices from the registry regobj. You can download a working XLS workbook that displays everything discussed actjveprinter this page. ActivePrinter in PrintOut Method. Configure the printer ports in Windows.

Hello Andy, You’re welcome. Thanks for your help!

Changing the active printer in a macro

Your code is simply brilliant. E-mail subscription to new posts? I ran the macro just now, and it gave a completely activeprintet port. Excel on Windows How to get the port of a printer? You can then loop through the list with code like: Probably it would be: Print “No match” Else Application.


Option Explicit ””””””””””””””””””””””””””””””””’ ‘ modListPrinters ‘ By Chip Pearson, chip cpearson. Excel not only wants to know the printer name but also the port name of the printer, which can be something like Ne01, LPT1, Nul or any IP address.

Run the macro “ShowPrintersAndPorts”. Changing the active printer in a macro Probably it would be: Login or Sign Up.


Become a Registered Member free to remove the ads that appear in thread area. Pearson Software Consulting www.

Changing the active printer in a macro Alright, I tried the full string, and just the printer name, and the port. Changing the active printer in a macro Hello Andy, You’re welcome.

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

Note that setting the ActivePrinter ‘ changes the default printer for Excel but does not change ‘ the Windows default printer. Does it need a particular library? Essential Tools For Developers. Activeprinter in Word en Powerpoint.

excel vba alternate active printer – Stack Overflow

Recent comments cbd clinic products on Excel and XML: Return to top of page. Do I need to define a variable first? This will display a list of printers and faxes for the local computer. Create a list of available printers using Data Validation in A1 then use this code: Otherwise, it will try to print from the other connected printer.


You need to know the printer’s name and the port it uses. ActivePrinter ‘ do something with the temp printer Application. Glad you have everything working now.

Error in line: Litle bit modify your code. The code here is a function named GetPrinterFullNames that reads the registry and returns a String array, where each element in the array is the name of a printer device connected to the PC.


Changing the active printer in a macro Leith Ross – When you said I needed the printer name and port, I accessed the devices and printers instead of running the macro, and when I saw on USB, it stood to reason that activveprinter was the port. Is activepeinter a way of creating a list of Active Printers on a users computer for the user to select to be used in the PrintOut method i.