Thread: Save As Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo[_2_] Ronbo[_2_] is offline
external usenet poster
 
Posts: 1
Default Save As Macro

I save files "name +date" such as. "dell may 03" date
always has the last six spaces . i.e. next month will
be "dell jun 03"

I am looking for a macro that after completing procedures
in a workbook would open the "Save As" dialog box and 1.
remove the previous date 2. save the file as "name + new
date" The update is always done in the month of the file
date.

Any help would be very much appreciated.