View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Doctorjones_md Doctorjones_md is offline
external usenet poster
 
Posts: 64
Default 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