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

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
 
D

Dave Peterson

application.displayalerts = false
yourworkbook.saveas ...
application.displayalerts = true
 
Top