View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default Save As Overwrite


Is there some way to keep the window
that tells me that a file already exists and
do I want to overwrite it from popping up
and let a worksheet save as execute?

give that fStr hold the name of the file


Set wb = ActiveWorkbook
wb.SaveAs (fStr)

is what I have now....but I get the message.