View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
faberk faberk is offline
external usenet poster
 
Posts: 8
Default Saveas where file already exists

I am trying to "saveas" the active workbook and would prefer to have the
system enter throught he prompt that the file exists and do i want to replace
it? In this particular case, I always with to replace it. My current is as
follows:

ActiveWorkbook.SaveAs (conSaveFilePath & strRespFileName)

conSaveFilePath is a file path constant and strRespFileName is a variable
containing the file name. Or...should i be dealing with this differently?

thanks