K
kcleere
I have a task that involves the following steps.
1. Open Excel file
2. Invoke Macro with customer menu button
3. After macro runs I select File-Save-As...then I change a date that
resides in the filename (looks like this) XXXX_todaysdate).xls
4. Close file (keep Excel open)
I know how to write the macro to save (as is) and close the file but I
don't know how to get it grab todays date and text it into the
filename before saving.
"Ideally"...I'd like to have the Macro rename the file with BOTH
todays date AND text in a fixed cell in the spreadsheet.
Such as: Monthly_Report_010107_.xls (Monthly Report) being the text in
the cell.
I have to run this on multiple files so I'd really like to see how to
automate this part.
Any suggestions you could give me would be appreciated.
Ken
1. Open Excel file
2. Invoke Macro with customer menu button
3. After macro runs I select File-Save-As...then I change a date that
resides in the filename (looks like this) XXXX_todaysdate).xls
4. Close file (keep Excel open)
I know how to write the macro to save (as is) and close the file but I
don't know how to get it grab todays date and text it into the
filename before saving.
"Ideally"...I'd like to have the Macro rename the file with BOTH
todays date AND text in a fixed cell in the spreadsheet.
Such as: Monthly_Report_010107_.xls (Monthly Report) being the text in
the cell.
I have to run this on multiple files so I'd really like to see how to
automate this part.
Any suggestions you could give me would be appreciated.
Ken