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
Dave Peterson - 17 Dec 2007 17:44 GMT
application.displayalerts = false
yourworkbook.saveas ...
application.displayalerts = true
> 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

Signature
Dave Peterson