Mutiple Instances of Excel - Which one will Windows use to open a file?

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi All,

If I have multiple instances of excel open, is there any way to
dictate which one will be used by Windows to open an excel workbook if
the user double clicks on it in windows explorer?

One of the instances will always have a modal userform open, so I need
to avoid that instance being used.

Thanks,

Alan.
 
... is there any way to
dictate which one will be used by Windows to open an excel workbook if
the user double clicks on it in windows explorer?
Click to expand...

Not that I know of.

One of the instances will always have a modal userform open, so I need
to avoid that instance being used.
Click to expand...

Application.IgnoreRemoteRequests = True will prevent further files
being opened in that instance.


Regards,
Vic Eldridge
 
Application.IgnoreRemoteRequests = True will prevent further files
being opened in that instance.
Click to expand...

Perfect!

I wasn't even aware of that one.

Thanks Vic - Much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TWO Instances of Excel One watching Other 3
Open a New Instance of Excel 3
Copying worksheet from hidden instance of Excel 1
Custom Form 3
Start my Application in its OWN instance? 2
Get Workbook path but from another excel instance 4
Copying a sheet from another Excel instance? 1
Force a File to Open in a New Excel Instance 3

Back
Top