Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. On Aug 28, 1:20 am, "Peter T" <peter_t@discussions wrote: 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add Menu Bar to User form | Excel Programming | |||
Visible automated Excel: automation crashes if user selects cells, protection? | Excel Programming | |||
Office Automation - Capturing Custom Menu Clicks | Excel Programming | |||
Persistent menu item with Excel Automation Add-in? | Excel Programming | |||
Knowledge gained from Access to Excel VBA Automation User request | Excel Programming |