I've been exploring alot of threads about this subject but haven't
found the right solution yet.

My problem is that i have an excel sheet with a vba form uploaded on
our intranet. When a user downloads this file and immediately opens it,
it wil open the form through the workbook_open event.
No problem so far.
But when this user has already an instance of excel running the
userform opens on the background in this instance and is not always in
focus.

What i want is to open this form in a new instance of excel if excel
is already running. I found a function that tests if excel is running.
But how can i control this workbook being opened in a new instance?
When i use the workbook_open event the choice has already been made for
me.

Anyone a good idea?

This is in dummy code what i want

If fIsAppRunning("Excel") Then
Set objXL = CreateObject("Excel.Application")
frmEAED.Show ' to open this form in the objXL instance



Regards,

Bert Nijkoops