"GS" wrote in message
...
Clif McIrvin presented the following explanation :
It's easy enough to discover if there are multiple instances running
by using Task Manager. On XP, my normal way to launch Task Manager is
Ctrl+Alt+Del which brings up a dialog and one of the choices is Task
Manager.

When Task Manager opens, select the Processes (NOT Applications) tab
and look for multiple entries for EXCEL.EXE.

If there's only one, there is only one instance running on that
computer.

Regardless of how many instances are running, the ref to Application
only applies the the instance in which the code is executing. Each
instance is the parent of its open files, and so open files in some
other instance aren't affected by any other instance running. Even if
2 instances have the same file open, the instance running the code
only works on objects of that instance.



True.

My thinking is simply that if Matthew *does* in fact have multiple
instances running then he will need to either adjust his operating
environment or change his strategy for dealing with it.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)