on 3/11/2011, Clif McIrvin supposed :
Absolutely. That's why, when he said your code wasn't working for him, I
questioned whether or not he had multiple instances.

So then, you're suggesting he thought the file was open but when he ran
the code in the instance he ran from, the file was not open in that
instance.

The casual observer would have no idea whether they were running
multiple instances or not.

Huh.., you might be right! I find it hard to believe, though, since one
must deliberately start another instance while an existing instance is
running.

Another possibility is that an automated instance is running with its
'IgnoreRemoteRequests' property set 'True' so when a user double-clicks
a file in explorer it starts the default instance of Excel. If the
author of the automated instance didn't change the Caption/Icon for the
running app then there'd be 2 Excel icons on the taskbar.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc