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: Zubar Nisho
Country: Bahamas
Language: English (Spanish)
Genre: Art
Published (Last): 12 April 2010
Pages: 205
PDF File Size: 13.4 Mb
ePub File Size: 18.59 Mb
ISBN: 465-8-64132-534-8
Downloads: 8264
Price: Free* [*Free Regsitration Required]
Uploader: Nekinos

Excel on Windows Does it need a particular library? Note that setting the ActivePrinter ‘ changes the default printer for Excel but does not change ‘ the Windows default printer. It does not change the default printer in Windows. Please use [code] tags when posting code.

ActivePrinter Property

Changing vha active printer in a macro Probably it would be: Create a list of available printers using Data Validation in A1 then use this code: I could not find any difference with my pc, where there is no such problem. Exit Function Do Start: The problem I typed?


To start viewing messages, select the forum that you want to visit from the selection below. Run the macro “ShowPrintersAndPorts”. Option Explicit ””””””””””””””””””””””””””””””””’ ‘ modListPrinters ‘ By Chip Pearson, chip cpearson.

How to set Excel’s ActivePrinter using VBA? •

Your code is simply brilliant. And do that on all machines of all users? I am bypassing the Print ativeprinter but some users want to print in colour so I need to be able to select other printers and pass the name to the PrintOut method At startup Excel will set Application.

Do I need to define a variable first? 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 There’s a property of the Application object called ActivePrinter.

Activeprinter in Word en Powerpoint. All times are GMT activeprinfer Please post data in proper tables – I suggest this tool.

You can download the bas file with all the example code on this aactiveprinter. Add a new VBA Module to workbook and paste the code below into it.

This is the code to test the function: We may share certain information about our users with our advertising and analytics partners. Do I make the code line application. Dialogs xlDialogPrinterSetup and ask the user to select the printer. Cite this page as: This will display a list of printers and faxes for the local computer.


ActivePrinter in PrintOut Method. This will get the list of availble printers. Help Contact Us Go to top. Just what I was looking for. The time now is Error in line: Return to activeprinher of page.

ActivePrinter Property | Microsoft Docs

You may have to register before you can post: Hello andy, You will need a little more information to set the ActivePrinter. ActivePrinter to your default printer, in my case usually a Laserjet. If this is your first visit, be sure to check out the Board FAQ by clicking the link above. I ran the macro just now, and it gave a completely different port.