Excel Macro Question
 

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?

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

http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

http://www.teachexcel.com/free-excel...-in-Excel.html

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

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

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