Hi,

There is a problem on the network I'm using where files are intermittently not released when a user closes Excel. This means that when the next user uses the file it will appear to be fine (ie. not read-only), but when they try to save it gives a message such as, "The file is in use. please try again later." (sorry don't have the exact wording to hand). If I make the file save from VBA I get an error 1004 (Application-defined or object-defined error).

I'm hoping to be able to detect when this will happen on opening so I can warn the user not to enter their data and to contact helpdesk but I can't figure out a way without forcing a save in the workbook open event (which is undesirable as it will cause a very slow load).

Any advice gratefully received,

Chinchin