Saving a file

I save and close a workbook with

Please Login or Register  to view this content.

Which works ok. But if a file of same name ( Test.xls ) exists then it opens the dialog box where I have to confirm if excel can overwrite the existing file. I don't want excel to ask me, just overwrite if file already exists. Can it be done?

A V Veerkar

Originally Posted by VBA Noob

Try

Please Login or Register  to view this content.

VBA Noob

Thanks a lot.

A V Veerkar