Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Autosaving an Excel Workbooks as versions
I'm wondering -- is there a way to automate saving an Excel Workbook whereas
you could (for example): You open an Excel template, and save it as C:\Temp\Test.xls -- then if you reopen (and modify) C:\Temp\Test.xls, the VBA code will search the directory and automatically affix an _a, _b, _c, _d, ... to the end of the file name (ie. C:\Temp\Test_d.xls -- if the last file saved was C:\Temp\Test_c.xls). Thanks in advance |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Autosaving an Excel Workbooks as versions
Use "SaveAs" on the File menu instead of "Save".
The open workbook will be closed and a new version saved under the name you assign... "Test_a.xls" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Doctorjones_md" wrote in message I'm wondering -- is there a way to automate saving an Excel Workbook whereas you could (for example): You open an Excel template, and save it as C:\Temp\Test.xls -- then if you reopen (and modify) C:\Temp\Test.xls, the VBA code will search the directory and automatically affix an _a, _b, _c, _d, ... to the end of the file name (ie. C:\Temp\Test_d.xls -- if the last file saved was C:\Temp\Test_c.xls). Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Versions of workbooks- Excel 2007 | Excel Worksheet Functions | |||
Does excel keep temporary versions of previouse workbooks once i s | Excel Discussion (Misc queries) | |||
Opening .xlsm workbooks in older versions of excel | Excel Discussion (Misc queries) | |||
Autosaving an Excel Workbooks as versions | Excel Discussion (Misc queries) | |||
Can Excel 2003 prompt before Autosaving? | Excel Discussion (Misc queries) |