Excel 2010 print settings


C

crossy75

I had a macro running for people on excel 2007 which changed the
printer to a pdf factory and print a number of pages (in specific
order, and from different sheets.)

the code i used was

Application.ActivePrinter = "pdfFactory on FPP3:"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=1,ActivePrinter:="pdfFactory Pro on FPP3:"

all the PC's have been upgraded to Excel 2010, and as a result it
doesnt seem to like changing the printer from excel.

does anyone have a route around this, or coding in 2010 that will set
a printer?

thanks
 
Ad

Advertisements

G

GS

crossy75 expressed precisely :
I had a macro running for people on excel 2007 which changed the
printer to a pdf factory and print a number of pages (in specific
order, and from different sheets.)

the code i used was

Application.ActivePrinter = "pdfFactory on FPP3:"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=1,ActivePrinter:="pdfFactory Pro on FPP3:"

all the PC's have been upgraded to Excel 2010, and as a result it
doesnt seem to like changing the printer from excel.

does anyone have a route around this, or coding in 2010 that will set
a printer?

thanks

Well.., it looks here like you specify two different printers. I'd
settle on 1 only and see how that works for you. Also, since you've
already specified Application.ActivePrinter, why are you duplicating
that in your PrintOut args?
 

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