Save one worksheet and as pdf

michaelsmithgall

New Member
Joined
Feb 22, 2011
Messages
19
I have a file that has several worksheets that i use as templates for various functions. These templates are mostly data entry forms and fairly simple pages of calculations<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
I would like to take one of these templates and save it as a PDF each time I update it based on 3 cells (account#, Name, Date) So I can keep a copy of any changes I make as new documents come in that affect the final numbers. <o:p></o:p>
<o:p></o:p>
Because I do not need the entire workbook saved I would like only this particular worksheet saved. And have it saved in the same folder. Right now I print this worksheet to a PDF and manually save the PDF under the file name of the account#, name and today’s date. I would like to save those steps and go right to a button that i link to this macro.<o:p></o:p>
<o:p></o:p>
Additionally I keep saying PDF but i create my PDF's through my print function and the printer is listed as PDFcreator. I assume this is an actual adobe program but not sure. <o:p></o:p>
<o:p></o:p>
So I need<o:p></o:p>
1. A work sheet saved as PDF based on three cells a1 a2 a3 to read like "C:\Documents and Settings\Mike\Desktop\Files\54697 Johnson 03142011.pdf"<o:p></o:p>
<o:p></o:p>
2. This to happen as a result of a button (I can link the macro to a button) I just don’t want a new file created each time I save my work<o:p></o:p>
<o:p></o:p>
3. Some sort of error handling that allows me to overwrite the previous version if I update throughout the same day (since the date is part of the file name) <o:p></o:p>
<o:p></o:p>
Thank you in advance for any help you may provide. Please ask any questions that would help clarify this for you. <o:p></o:p>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
I didnt expect this to be that hard. Maybe i cant make the request simpler. Can i just have a file saved with just one of the tabs rather than they whole thing?

i really want that one tab saved as a pdf but it didnt look like anyone is biting on that. So if i cant save this one worksheet under its own file name using the three cells to create the file name that would be atleast a step in the right direction.
 
Upvote 0

Forum statistics

Threads
1,224,590
Messages
6,179,750
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top