| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
saving documents with macros
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving custom toolbars with macros to work on other computers | Excel Discussion (Misc queries) | |||
| saving with macros in excell | Excel Discussion (Misc queries) | |||
| Saving Macros | Excel Discussion (Misc queries) | |||
| Macros making file saving extremely slow. | Excel Discussion (Misc queries) | |||
| Saving Macros | Excel Worksheet Functions | |||
Linear Mode
