![]() |
€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. |
![]() |
#1 |
Prepping...
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
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? |
![]() |
Submit to Quotes
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|