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.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc