Hi,

I need to send out reports every two weeks coming from a single updated master data file. Every two weeks, I would like to run my macro to :

- export each sheet from the master data file to a new workbook
- create a new folder with a timestamp
- name the workbook with the sheet name along with a timestamp
- save the workbook to the newly created folder

Therefore I would get a new folder every two weeks containing the reports. My VBA is kind of wobbly. I've been trying and understand the basics but just can't get the code to work to my specifics.

The next step would be to get my macro to send out the files to the recipients but I'll worry about that next.

Thanks for your help !
Amphinomos