View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobMack RobMack is offline
external usenet poster
 
Posts: 9
Default How to repeat "save as" in Macros

I have a procedure whereby files need to be automatically saved, "save as".
How can I code the procedure so that it will rename the file and I don't get
the error message that "file already exists, do you want to replace"?