Thread: Say 'YES' to overwrite file
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike G.[_2_] Mike G.[_2_] is offline
external usenet poster
  
Posts: 2
Default Say 'YES' to overwrite file
Thanks
-----Original Message-----
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=fsn
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Mike G." wrote in message
...
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




.

Reply With QuoteReply With Quote