I have a data file in which cell A1 has date in mm/dd/yyyy format .
I want a macro which will save that document as xls file in a folder specific to that day.
Basically want to create folder and then save in the same .location is c:/data/
For example if date is 06/15/2013
Then it shoudl make folder 2013 in data folder . Then subdirectory named june in 2013 and then make date folder and save in it.
So the path will be c:/data/2013/june/15.
Thanks in advanced ,