oloffcrous
New Member
- Joined
- Dec 7, 2016
- Messages
- 2
Hi All
I have a client that requests multiple quotes from various people within my organisation, posing the threat of different costs going out. We have mitigated this by developing a Quote Tool that is managed by one person and each new quote needs to be done on a fresh copy of this default template.
The continuous influx of requests has prompted me to automate even the automatic creation of a PDF file in the working directory, thank you Mr Excell for that script....
I have also found a way to automatically enter the desired file name in the File Save As promt, saving another copy and paste action, thank you Mr Excell for that script... again
My last automated functions are are a difficult one:
As part of the process, we copy a new template to the required folder. This file is named "Template Dec 2016"
Problem 1 - As part of the File Save As script, I select a cell value and it populates the file name. The location it selected defaulted to My Documents, but I can select a desired folder if I wish. I would however like it to select the folder I opened the file from.
Problem 2 - I would like to save the file, overwriting the file I opened. The file is called "Template Dec 2016", the cell value pastes "Date+Site+Person" into the file name and save it as such. Can I perhaps automatically delete the file I opened after I saved it as the new file name?
I hope this makes sense
!!!
Oloff Crous
Cape Town
South Africa
I have a client that requests multiple quotes from various people within my organisation, posing the threat of different costs going out. We have mitigated this by developing a Quote Tool that is managed by one person and each new quote needs to be done on a fresh copy of this default template.
The continuous influx of requests has prompted me to automate even the automatic creation of a PDF file in the working directory, thank you Mr Excell for that script....
I have also found a way to automatically enter the desired file name in the File Save As promt, saving another copy and paste action, thank you Mr Excell for that script... again
My last automated functions are are a difficult one:
As part of the process, we copy a new template to the required folder. This file is named "Template Dec 2016"
Problem 1 - As part of the File Save As script, I select a cell value and it populates the file name. The location it selected defaulted to My Documents, but I can select a desired folder if I wish. I would however like it to select the folder I opened the file from.
Problem 2 - I would like to save the file, overwriting the file I opened. The file is called "Template Dec 2016", the cell value pastes "Date+Site+Person" into the file name and save it as such. Can I perhaps automatically delete the file I opened after I saved it as the new file name?
I hope this makes sense
!!!
Oloff Crous
Cape Town
South Africa