saving documents with macros

S

shrek

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
 
B

bpeltzer

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
 
Top