View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TaffyBlue74 TaffyBlue74 is offline
external usenet poster
 
Posts: 2
Default Save As with Different Version Name

I need to be able to open a workbook, and then when it is closed it
automatically saves it in the same folder but with an updated name eg.
Spreadsheet Ver 1, Spreadsheet Ver 2? I want this function to work without
the user physically having to Save As.