saving documents with macros
Your macro will have to use the SaveAs method and 'calculate' the filename.
Something like
ActiveWorkbook.SaveAs Filename:="c:\output\" & Format(Date, "yymm") & ".xls"
--Bruce
"shrek" wrote:
I have a spreadsheet which I save with a different number every month
i.e 0601,0602 and so on. Im trying to set a macro up so it
automatically saves the file and increases the number by one so it dont
overwrite the existing file.
Anyone any ideas how I can do this.
Many Thanks
--
shrek
|