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-comfficeffice" /><o></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
So I need<o></o>
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></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
Thank you in advance for any help you may provide. Please ask any questions that would help clarify this for you. <o></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
So I need<o></o>
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></o>
<o></o>
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></o>
<o></o>
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></o>
<o></o>
Thank you in advance for any help you may provide. Please ask any questions that would help clarify this for you. <o></o>