Vba code to create new folders and subfolders [Closed]

Report
Posts
1
Registration date
Wednesday June 24, 2015
Status
Member
Last seen
June 24, 2015
-
Hello,

Pls could anyone show me a code that will allow me to save an excel file as follows:

Year/month/week/myexcel.xsl
Year- I will like it to search if year exist. If not create one
Month- I will like it to so the same as year
Week - I will like to create a new folder(if it doesn't exist) as wk+date
Then my excel file

Many thanks


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!