Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I had no joy with my other post 'Trying to read
CustomDocumentProperties of an open 2007 AddIn Options ' so I'm trying another tack... To work around a problem I'm having, since upgrading a complex tool to Excel 2007, I need to ensure that my Version Checker AddIn always opens before my Engine AddIn. Is there any useable logic that dictates the order in which Excel opens its installed AddIns (e.g. alphabetical, order of installation, position in list) or is it one of those unknown internal processes that will forever remain a mystery? Br, Nick. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First ComAddins and automation addins load, then addins load in the order
they were installed. See here HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options and look at the OPEN's Guessing at your objective, instead of installing your "Engine" addin why not get your "Version Checker" to load it. Either in its own open event or get Version checker to add a button to the toolbar (ensure the onaction includes full path). It will then load on user's demand. Regards, Peter T "Nick H" wrote in message ... I had no joy with my other post 'Trying to read CustomDocumentProperties of an open 2007 AddIn Options ' so I'm trying another tack... To work around a problem I'm having, since upgrading a complex tool to Excel 2007, I need to ensure that my Version Checker AddIn always opens before my Engine AddIn. Is there any useable logic that dictates the order in which Excel opens its installed AddIns (e.g. alphabetical, order of installation, position in list) or is it one of those unknown internal processes that will forever remain a mystery? Br, Nick. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Peter
Useful info and I like your suggestion of loading the Engine via the Version Checker. Why are the simplest and most obvious ideas always the most elusive? <g Br, Nick. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to open and close addins | Excel Programming | |||
Changing the order the addins load | Excel Discussion (Misc queries) | |||
How to change the order in which excel addins gets loaded? | Excel Discussion (Misc queries) | |||
=Why AddIns.Installed can be out of range= | Excel Programming | |||
=Why AddIns.Installed can be out of range= | Excel Programming |