New menber needs a macro to open a template, save as with tomorrows date in diff folder

Hi everyone,

I need to write a macro that will open an existing excel template file in a folder named 'originals' located on the computer desktop

then

Perform a save as having the next days date as the spreadsheet (workbooks) new name in order to not overwrite the template
in the format mm day year

like this: 06302014 month/day/year

into a specified folder on our C drive, (not a network drive) named whatever the current month is. So for example I would want to save the spreadsheet (workbook) in a folder called June

This spreadsheet is used 365 days a year and the month folders are simply called January, February, March etc.

This macro has to be very easy to use because most of the security staff have little or no computer experience.

I can program in HTML, C++ and am now self-learning V-Basic

Thanks very much
Chris in RD AB

Hello shikano53,

Welcome to the Forum!

Where is this macro to be run from?

How will the user activate the macro - Picture, Button, Ribbon item?

Hello Chris,

the macro could run automatically at a specific time, provided the workbook remains open. A manual option, like a button, could be included to run it as well. Using both will ensure the template is copied.

I can write macros that will be compatible with Office 2003 and later it's later versions.