Autosaving an Excel Workbooks as versions

  • Thread starter Thread starter Doctorjones_md
  • Start date Start date
D

Doctorjones_md

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
 
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"
<[email protected]>
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
 
Back
Top