now stage two...

[jimmywanna]

I have two printers, Obviously one is set as default. I need the outcome of my workbook (in my case a label) print on the non-default printer.
Can i record a macro which will select the non default printer?

If i can i will then use the Sub AutoOPen()
to do that as soon as the workbook is opened.

is this possible?

 

[Iridium]

Just recorded this macro on my PC selecting a printer other than my default -

Application.ActivePrinter = "\ukcwdsprtacdtek74003 on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\ukcwdsprtacdtek74003 on Ne01:", Collate:=True

Seems if you specify what the printer name is in your macro then it should work as you want it to

 

[DonkeyOte]

Sub SwitchPrinter()

Dim strActivePrinter As String

' Get active printer.
strActivePrinter = Application.ActivePrinter

' Change to another printer Application.ActivePrinter = "\NTS1HP5000 on Ne01:"

' Reset printer to original default Application.ActivePrinter = strActivePrinter

End Sub

Pretty much the same code...but I guess you could specify this before running the remainder of the macro...