Excel 2010 print settings

[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

 

[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?