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
Bookmarks