microsoft.public.excel.programming

Jim Cone

12/18/2006 7:48:00 PM

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/primiti...


"Doctorjones_md"
<xxxDoctorjones_mdxxx@xxxyahoo.com>
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