Still Struggling with PRINTER--Macro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top