Edward,
If this is a problem, you can set Application.IgnoreRemoteRequests=True, so
any files opened from Explorer will open in their own instance of Excel.
However, you then have a problem of communicating between the 2 instances.

However, it still seems that it would be better to use the various
Activate/Deactivate events to solve your problem.

NickHK

"Edward" <Edward@discussions.microsoft.com> 撰寫於郵件新聞:7F50CE52-F8AE-44B0-A352-D65BDE4B9DD3@microsoft.com...
> Well, it appears that when you open a Workbook in Excel for the first time
> it
> opens it in an instance of Excel. Subsequent Workbooks that are opened,
> are
> opened in the same instance of Excel. This causes problems when running
> macros since there is only one thread of execution.
>
> This can be solved by opening separte instances of Excel (Excel.exe
> shortcut) and then opening the target file through the File > Open
> command.
> The problem with this is that typical Excel users don't open files this
> way.
>
> It seems to be a "feature" in Excel. A "feature" that I am too happy about
> but there appears that nothing can be done.
>
> Thanks everybody for their help.
>
> Ed
>