G
Guest
I tried the below formula and it doesn't work properly.
It's a macro. What I would like to do is print certain
worksheets within a workbook on printer\\ALBPRN01\finlj02
and once it's done printing, I want the printer to default
to\\ALBPRN02\finlj02....no matter what I do, it keeps
defaulting to \\ALBPRN01\finlj02 ...can anyone assist with
the macro formula to have this work?
Application.ActivePrinter = "\\ALBPRN01\finlj02 on
Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Preview = ActivePrinter = "\\ALBPRN02\finlj02 on Ne03:"
Collate = True
It's a macro. What I would like to do is print certain
worksheets within a workbook on printer\\ALBPRN01\finlj02
and once it's done printing, I want the printer to default
to\\ALBPRN02\finlj02....no matter what I do, it keeps
defaulting to \\ALBPRN01\finlj02 ...can anyone assist with
the macro formula to have this work?
Application.ActivePrinter = "\\ALBPRN01\finlj02 on
Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Preview = ActivePrinter = "\\ALBPRN02\finlj02 on Ne03:"
Collate = True