Excel Macro Question

[BarTopDancer]

I have a multi-page workbook that I created macros to print specific worksheets in groups.

What I would like to do is have the macro select a specific printer (CutePDF) instead of printing to the default printer.

So far, if I manually change the default printer on my PC to CutePDF it will bring up the "save as" prompt for each grouping and the file names are all the same.

I want to eliminate having the user change their default printer every time.

Is there a way to change the default printer within the Macro and also only have one 'save as' prompt for the entire macro that will compile and save each grouping?

[Moonliner]

The PrintOut Method has an option for "ActivePrinter" I'd start there.

http://msdn.microsoft.com/en-us/library/office/bb179158%28v=office.12%29.aspx

http://www.teachexcel.com/free-excel-macros/m-64,Complete-Guide-to-Printing-in-Excel-Macros-PrintOut-Method-in-Excel.html

[Moonliner]

Did that get you headed in the right direction or does it need a closer look?

[BarTopDancer]

Sorry Moonie! I totally thought I replied. It's actually for a user I was helping and she is testing it over the weekend.

[lashbear]

Well dont ask me! Im having fun trying to learn "Numbers" on the new Pootie. Its frustiingrating :blush: