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. :-)
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.
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.
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
