Thread: File saving
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Avner Mediouni Avner Mediouni is offline
external usenet poster
 
Posts: 8
Default File saving

Hi All,
I would to write a macro that saves automatically an open workbook with the
name that is on cell B2, but if the file already exist the macro add a
"running number" to the file name (i.e. FileName1, FileName2,etc.,)

Can anyOne help?

Thanks'
Avner Mediouni
R&D Physicist