Program

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Zischke - 23 Mar 2006 00:16 GMT

Hi all,

Is there a way to prohibit another excel file opening up in the same window
as the program that I have created?

Jason

Reply to this Message

Jim Thomlinson - 23 Mar 2006 00:30 GMT

Nope... Having multiple instances of Excel running is problematic anyways. My
recommendation would be to figure out how to do whatever you want to do in
one instances.

Signature

HTH...

Jim Thomlinson

> Hi all,
>
> Is there a way to prohibit another excel file opening up in the same window
> as the program that I have created?
>
> Jason

Reply to this Message

NickHK - 23 Mar 2006 02:47 GMT

Jason,
If you use Application Level Events you can trigger code that runs when a WB
is opened.
However it has no cancel, so would have react after it is open.

See www.cpearson.com/excel/AppEvent.htm

NickHK

> Hi all,
>
> Is there a way to prohibit another excel file opening up in the same window
> as the program that I have created?
>
> Jason

Reply to this Message

Vic Eldridge - 23 Mar 2006 05:31 GMT

Application.IgnoreRemoteRequests = True
will prevent other files from being opened when you double-click them in
Windows Explorer, if that's what you mean.

Regards,
Vic Eldridge

> Hi all,
>
> Is there a way to prohibit another excel file opening up in the same window
> as the program that I have created?
>
> Jason

Reply to this Message