save worksheet as pdf in current location

January 13, 2013 at 21:15:14
Specs: Windows Vista
hello everyone
I would like to save the active worksheet as pdf in the current directory with name as a cell value. Please sort out this problem.
Thanks in advance. :-)

See More: save worksheet as pdf in current location

January 14, 2013 at 00:30:17
I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.

Report •

January 14, 2013 at 04:39:13
I can't tell if your 2nd post is a question or if you are telling us that you found a solution.

Please clarify what you are trying to accomplish.

When referencing a solution found in this forum, please provide a link so that we can see what you are referring to.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 15, 2013 at 22:20:16
oh sorry actully I want to print the activework sheet to the default printer , and then save the worksheet as pdf in the desktop, after saving in pdf change set the printer to default printer.

I have tried this using macro its doing both tasks seperatly but not together i.e.
if I am printing to default printer, its prining but giving error to print on pdf after that
but if I am printing directly on pdf yhe code is wrking properly.

I wish to print to default printer as well pdf

Report •
Related Solutions

Ask Question