LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 355
Default Printing Macro question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
An IF question plus Printing Macro sahafi Excel Worksheet Functions 0 March 20th 08 03:33 PM
macro printing question Pete W. Excel Discussion (Misc queries) 1 January 9th 07 07:35 AM
Printing question Otto Moehrbach Excel Discussion (Misc queries) 3 November 24th 06 03:56 PM
Printing Question spartanmba Excel Discussion (Misc queries) 1 January 27th 05 09:57 PM
macro printing question cb Excel Programming 4 August 9th 04 04:52 PM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"