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?