Can you tell how Excel is launched?

[Guest]

We have an Excel add-in. We would like to know if the application is started
from the menu by the user or started by another Office application. Is using
the ConnectMode parameter in the OnConnection call the best way to do this?

 

[Jake Marx]

Hi Gail,

We have an Excel add-in. We would like to know if the application is
started from the menu by the user or started by another Office
application. Is using the ConnectMode parameter in the OnConnection
call the best way to do this?

Not sure this will help, but look at the UserControl property of the
Application object. Note that this will only give you a definitive answer
if the app was created programmatically AND is hidden.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Guest]

Thanks! That worked perfect.

Hi Gail,

We have an Excel add-in. We would like to know if the application is
started from the menu by the user or started by another Office
application. Is using the ConnectMode parameter in the OnConnection
call the best way to do this?

Not sure this will help, but look at the UserControl property of the
Application object. Note that this will only give you a definitive answer
if the app was created programmatically AND is hidden.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Guest]

Is there a way to determine what application launched Excel?

Thanks,
Gail

Hi Gail,

We have an Excel add-in. We would like to know if the application is
started from the menu by the user or started by another Office
application. Is using the ConnectMode parameter in the OnConnection
call the best way to do this?

Not sure this will help, but look at the UserControl property of the
Application object. Note that this will only give you a definitive answer
if the app was created programmatically AND is hidden.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]