Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default In what order do installed AddIns open?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default In what order do installed AddIns open?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default In what order do installed AddIns open?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to open and close addins Steph Excel Programming 2 January 29th 10 11:07 PM
Changing the order the addins load havenlad Excel Discussion (Misc queries) 2 June 16th 07 12:13 AM
How to change the order in which excel addins gets loaded? Joseph Excel Discussion (Misc queries) 0 June 24th 05 07:56 AM
=Why AddIns.Installed can be out of range= Tom Ogilvy Excel Programming 2 January 14th 05 09:37 PM
=Why AddIns.Installed can be out of range= hcova[_2_] Excel Programming 0 September 21st 04 06:37 PM


All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"