Hi all,

Could anyone tell me if it is possible to get a file to save as follows:

filepath\folder called "YYYY"\folder called "MMM"\File.xls

where YYYY is the year and MMM is the month?

The folders YYYY and MMM may or may not exist. Is it possible to get excel to create them if they do not already exist?

thanks very much

hriggs