Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.basic.visual.misc > #882

Re: Using regsvr32 question

Show all headers | View raw

These are MS Office COMAddins that are registered during install. My 
understanding from Excel developer sources is that these components 
'normally' install under HKCU/SOFTWARE/Microsoft/Office/Excel/Addins so 
they are accessible to users via the 'COM Addins Manager' dialog for 
runtime addin management, and NOT loaded in auto-instances of their 
host app. Putting them under HKLM (same path) prevents them from being 
accessible by users for runtime addin management and are ALWAYS loaded 
into their host app.

I don't understand why a author would insist on always loading their 
DLL when they know full well that this breaks the convention practiced 
by most everyone in the Excel development community. There's no issue 
with pre 2007 versions, only with MSO versions that implement the 
Ribbon. In this case any custom menus/toolbars appear on the Addins 
tab, which would normally be empty if people followed convention. All 
it takes is making their addin 'version-aware' so it behaves 
appropriately.

Now I must determine how to handle this going forward since it appears 
the Ribbon is here to stay. I can enumerate the key and grab all the 
'LoadBehavior' settings into an array, modify the values, then restore 
the original settings at shutdown. OR, I could simply set them how they 
should be set for auto-instancing and leave them that way (rather 
irresponsible). OR, I can abandon my approach and create my own custom 
tab and turn all the other ones off while my app is running. This, 
however, is the least desireable approach because it requires separate 
projects for early/late versions since the Ribbon gets managed by the 
imbeded xml in the XLAM. Currently, I use the same XLA for all versions 
of Excel and lock down the UI so only my menus appear on the Ribbon's 
Addins tab and all other tabs are hidden. Unfortuantely, the author 
doesn't give a crap about convention and version-aware practices.

-- 
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Using regsvr32 question GS <gs@somewhere.net> - 2012-03-07 00:27 -0500
  Re: Using regsvr32 question Deanna Earley <dee.earley@icode.co.uk> - 2012-03-07 08:51 +0000
    Re: Using regsvr32 question GS <gs@somewhere.net> - 2012-03-07 04:34 -0500
      Re: Using regsvr32 question Deanna Earley <dee.earley@icode.co.uk> - 2012-03-07 10:24 +0000
        Re: Using regsvr32 question Deanna Earley <dee.earley@icode.co.uk> - 2012-03-07 10:31 +0000
      Re: Using regsvr32 question "Mayayana" <mayayana@invalid.nospam> - 2012-03-07 09:58 -0500
        Re: Using regsvr32 question GS <gs@somewhere.net> - 2012-03-07 18:52 -0500
      Re: Using regsvr32 question "Farnsworth" <nospam@nospam.com> - 2012-03-07 22:24 -0500
        Re: Using regsvr32 question GS <gs@somewhere.net> - 2012-03-07 23:19 -0500
          Re: Using regsvr32 question "Mayayana" <mayayana@invalid.nospam> - 2012-03-08 08:53 -0500
            Re: Using regsvr32 question GS <gs@somewhere.net> - 2012-03-08 09:33 -0500

csiph-web