....'IgnoreOtherApplication'.

One of my books references in passing, the IgnoreOtherApplications VBA
command so that double-clicking an XLS file in Explorer won't use my instance
of Excel.

I want to use this, but when I type in as far as "Application.Ig"VBA code,
the predictive help only shows 'IgnoreRemoteRequests'.

Will IgnoreOtherApplication still work, or do I need a different command?
Its Excel 2002.

Thankyou.

Ignore other applications and ignore remote requests is the same thing... Be
careful using this code as it is a presistent setting and if your code bombs
in some way and fails to return this setting to it's original position you
are going to end up with a buch of very confused users... Good error handling
is necessary.
--
HTH...

Jim Thomlinson


"dim" wrote:

...'IgnoreOtherApplication'.

One of my books references in passing, the IgnoreOtherApplications VBA
command so that double-clicking an XLS file in Explorer won't use my instance
of Excel.

I want to use this, but when I type in as far as "Application.Ig"VBA code,
the predictive help only shows 'IgnoreRemoteRequests'.

Will IgnoreOtherApplication still work, or do I need a different command?
Its Excel 2002.

Thankyou.

Thankyou.

I haven't really learned how to enter error handling code yet, so I figure I
can't go wrong putting it in the AutoOpen macro, and disabling it in the
AutoClose. I'll put it in at the very end of development when I know that
none of my code is going to go bust when executed.......