Say 'YES' to overwrite file
"Mike G." skrev i melding
...
I want my script to automatically reply "YES" when
prompted if I wish to overwrite a file.
No, you don't want the question there in the first place:
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=fsn
Application.DisplayAlerts = True
HTH. Best wishes Harald
|