saving documents with macros

[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


--
shrek

[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

"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
>