Surpress message "The file ****.xls already exists"

  • Thread starter Thread starter Leksie
  • Start date Start date
L

Leksie

What piece of VBA script is needed to surpress the message "The file ****.xls
already exists. Do you want to replace the existing file?"

Thanks,
Alex
 
application.displayalerts = false
yourworkbook.saveas ...
application.displayalerts = true
 
Back
Top