Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
Im using the following code to print: Private Sub CommandButton2_Click() Sheets(Array("Sheet1", "Sheet2")).Select Application.ActivePrinter = "\\s45657\hp deskjet 6122 series on Ne02:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True I want to run the macro from other machines that have the same printer attached but not the same "NE01". I presume this number is assigned as the printer is installed. In that that have several different sheets that print at different printers, it is not practical for a choose printer dialog. Is there anyway to reassign the NE numbers outside of removing and reintalling the printers in the same order? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
An IF question plus Printing Macro | Excel Worksheet Functions | |||
macro printing question | Excel Discussion (Misc queries) | |||
Printing question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Discussion (Misc queries) | |||
macro printing question | Excel Programming |