Auto Create Folders
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?
|