Add-In has menu for user but not for Automation ?

[northof40]

Hi - I'm using an AddIn which when added creates a menu. The same
workbook when opened via C#/interop shows that that the AddIn is
present and installed but the menu is not there.

I'm not an Excel expert - is this surprising behaviour in an AddIn ?
The same user runs Excel ' manually' as runs the .EXE which automates
Excel - I don't understand why their experience is different.

Could anyone suggest a means to make the menu visible ?

thanks

Richard.

 

[Peter T]

When Excel is started by automation, addins and files in the startup folder
(eg Personal.xls) are not loaded. It's up to the app that automated Excel to
load any installed addins if/as required. Should also note that in this
scenario Auto_Open & _close routines will not automatically run (can use
RunAutoMacros)

Regards,
Peter T

 

[northof40]

Hi Peter - Thanks very much for this. It throws light on a number of
things I have seen in trying to automate Excel - I will try the
RunAutoMacros idea.

regards

R.