I need to save each sheet in my workbook [Except for the sheet named Rec]
The path is C:\Cpn\CA\Events\Red\2015 [which will change every year] \Mar 15 [which will change each month]
*I would like the macro to create a folder for year and month if there is no folder already there
the file name will be the sheet name and then the name in cell C38 from Sheet named Rec.
so file name would be like: Book3 - AB123456 - Red - 160315 [book3 being sheet name] [ - AB123456 - Red - 160315 being in cell C38 in sheet Rec]
so file path and name would be: C:\Cpn\CA\Events\Red\2015\Mar 15\Book3 - AB123456 - Red - 160315.xls
Thanks in advance