Auto Create Folders
Clear a couple of things up in my head -
is 03.07.06 a folder or is it going to be the filename. As shown I presume
it's a folder?
If that's correct, then can we assume that the name of the workbook does not
change?
You say the full file path is in cell P31 - does that include the workbook
name as
S:\Advisors\Access Operations\Advisor Maintenance Forms\07.
July\03.07.06\thisfile.xls
or just up to the 03.07.06 point??
"PaulW" wrote:
I have a weekly spreadsheet that needs saving into a new folder based on the
current date and month
eg Todays file location would be S:\Advisors\Access Operations\Advisor
Maintenance Forms\07. July\03.07.06
The bit upto 07. July is static and i have formulas hidden in the
spreadsheet to work out what the file location should be. The full file
location is in cell 'P31' but i can split it up.
The file is saved into the relevant week the blanked then saved back to the
root directory of 'S:\Advisors\Access Operations\Advisor Maintenance Forms'
All this is written.
What i need to do to make the system completly automated is to create the
folders automatically!
Can anyone help?
|