This one has me scratching my head...
I need my macro to save the workbook in its default location each time it runs. I'm doing this with:
Application.DisplayAlerts = False/True
at the beginning and end of my routine. The file simply saves where it already is, and my macro doesn't need to know what its name is. The problem is:
I want the macro to save two versions of the spreadsheet. The first as it already is, and the second (after a small manipulation in my routine) as the same filename & directory with a string " - string".xls tacked on the end of the filename.
e.g. directory/filename" - string".xls
How do I do this without explicitly stating the filename or file directory at some point within my macro?
Bookmarks