Hi

I am trying to right a macro in vba to save the master template I am working on as the previous month's name and year and create a new folder to save it in which is called the previous month's name. I also want the new renamed version of the spreadsheet to be left open after the button has been pressed.

I have tried a few different things but can't work out how to create the new folder in the correct location I want to save.

I want the file name to read 'July 2014' for example, and the new folder I want it saved in to be created in the following file path: I:\Sales \Reports and called 'July'.

Any help will be appreciated. I tried to find another similar thread but couldn't find one where I could work the code how I wanted.

Thanks