Excel Macro Question

BarTopDancer · 08-15-2012, 10:07 AM

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 · 08-15-2012, 10:19 AM

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

Moonliner · 08-17-2012, 03:49 PM

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

BarTopDancer · 08-18-2012, 10:37 AM

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 · 08-22-2012, 09:17 PM

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

08-15-2012, 10:07 AM	#1
BarTopDancer 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? __________________ Spork is the new MacGyver Postcards From My Edge
	Submit to Quotes

08-15-2012, 10:19 AM	#2
Moonliner 8/30/14 - Disneyland -10k or Bust. Join Date: Jan 2005 Posts: 9,022	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 __________________ - Taking it one step at a time.
	Submit to Quotes

08-17-2012, 03:49 PM	#3
Moonliner 8/30/14 - Disneyland -10k or Bust. Join Date: Jan 2005 Posts: 9,022	Did that get you headed in the right direction or does it need a closer look? __________________ - Taking it one step at a time.
	Submit to Quotes

08-18-2012, 10:37 AM	#4
BarTopDancer Prepping... Join Date: Jan 2005 Location: Here, there, everywhere Posts: 11,405	Sorry Moonie! I totally thought I replied. It's actually for a user I was helping and she is testing it over the weekend. __________________ Spork is the new MacGyver Postcards From My Edge
	Submit to Quotes

08-22-2012, 09:17 PM	#5
lashbear SwishBuckling Bear Join Date: Jan 2005 Location: In Isolation :) Posts: 6,597	Well dont ask me! Im having fun trying to learn "Numbers" on the new Pootie. Its frustiingrating __________________ *I Heart* my Husband - I can't think of anyone I'd rather be in isolation with.**
	Submit to Quotes