You could try setting it as a shared workbook, and set the settings to always
overwrite other users changes (In 2007 its on the "review" tab). You could
also change the Windows permissions to allow it to open to "read only" for
all other users and "read/write" for you (assuming others won't need to
modify the file).

"Jay" wrote:

Thanks in advance.

My module(not Excel VBA) genrated automatically every two hours an Excel
File (Performance.xls) to a predefined network folder.
Since somebody leave this file open, 'File Sharing Violation' error happens
and it is not being updated at all.

Q1. Is there any way to overwrite even he file is open.
Q2. If not, at leaset to close error dialog box.

Appreciated