Lounge of Tomorrow

€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides.  


Go Back   Lounge of Tomorrow > A.S.C.O.T > Egg Head
Swank Swag
FAQ Members List Calendar Search Today's Posts Mark Forums Read Clear Unread

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old 08-15-2012, 10:07 AM   #1
BarTopDancer
Prepping...
 
BarTopDancer's Avatar
 
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
BarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of cool
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?
__________________
Spork is the new MacGyver



BarTopDancer is offline   Submit to Quotes Reply With Quote
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 12:59 PM.


Lunarpages.com Web Hosting

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.