View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike G. Mike G. is offline
external usenet poster
 
Posts: 4
Default Say 'YES' to overwrite file

Dear Guru's and Experts:

I'm sure this is a simple one for you.

I want my script to automatically reply "YES" when
prompted if I wish to overwrite a file.

My existing coding is ...
'Save the file
ActiveWorkbook.SaveAs Filename:=fsn

Your guidance and help is appreciated and gives me more
knowledge.

Best regards, Mike