View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Macro help - "Save As" when a file already exists

I am using a macro to populate an existing file and then password protect the
file. Since the file already exists, I get the do you want to save over the
existing file message. I do want to save over the existing file. When I
recorded the macro, it does not include the response to the save over the
existing file question. Is there code to make the macro save over the
existing file?

Thanks