justundertall
New Member
- Joined
- Mar 22, 2021
- Messages
- 21
- Office Version
- 2013
- Platform
- Windows
Good day,
I wasn't able to find a thread on this so I hope that I'm not asking something that was already answered.
I currently have a button that will save a specific worksheet as a pdf to a specific folder with a specific file name using a specific amount of info based on the spreadsheet (customer Name, JobName, Estimate Number)
My question is if I save it more than once it seems to overwrite the current document. I need to keep track of every change made to the Estimate so I don't want it to overwrite the document save previously. I want to make a duplicate and have the file name based on the same info (customer Name, JobName, Estimate Number) but have a number (1) or a (2) behind it depending on how many times it been saved.
Is that even possible? if this is possible then i will need to do the same thing for the whole work book and save it as a an excel workbook the same way.
this is the current code i have
this is a snip of the spreadsheet that the file name is based off of
and this is the file where it is saving to and how the file name turns out based on the info from the spreadsheet
thanks for the he
I wasn't able to find a thread on this so I hope that I'm not asking something that was already answered.
I currently have a button that will save a specific worksheet as a pdf to a specific folder with a specific file name using a specific amount of info based on the spreadsheet (customer Name, JobName, Estimate Number)
My question is if I save it more than once it seems to overwrite the current document. I need to keep track of every change made to the Estimate so I don't want it to overwrite the document save previously. I want to make a duplicate and have the file name based on the same info (customer Name, JobName, Estimate Number) but have a number (1) or a (2) behind it depending on how many times it been saved.
Is that even possible? if this is possible then i will need to do the same thing for the whole work book and save it as a an excel workbook the same way.
this is the current code i have
this is a snip of the spreadsheet that the file name is based off of
and this is the file where it is saving to and how the file name turns out based on the info from the spreadsheet
thanks for the he