Excel Error 55, File already open

[olympus]

Sometimes my networked Excel application generates an Error #55:

"Samplefile.xls is already open. Reopening will cause any changes to be discarded. Do you want to re-open?"

The app runs fine regardless if I answer yes or no to this question.
I would like to write some visual basic code to hide and clear this message. I would ONLY like to supress error 55 messages. Thanks.
John

 

[AnotherHiggins]

How about just using

[blue]Application.DisplayAlerts = False[/blue] immediately before the Open command and [blue]Application.DisplayAlerts = True[/blue] immediately after?

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.