Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel com addin not loading at startup (Excel 2000)

    We have a COM addin that is registered and the registry setting is set to load it at startup( setting = 3). It doesn't get loaded and it doesn't appear in the COM Addin's list. When we browse to it to load it, we can select it but it still doesn't appear in the list. I have seen this behavior before on another COM addin, many months ago then it went away, i.e. it would load correctly, but this new COM addin is never loading yet it use to. Any ideas

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel com addin not loading at startup (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Jim

    OK is the COM add-in in the right folder for the right Excel version?

    What happens if you place a short cut, or even the add-in itself in the XLStart folder?

    Who wrote the code for it? Does it have any auto-destruct for not paying royalty fees for usage or what have you? Maybe an auto close if the version of Excel is not the right one?

    Does it need any other add-ins to run, maybe it is dependant on something that is not loaded.

    Try some of these, and let us know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel com addin not loading at startup (Excel

    Many COM Add-ins are registered only on a per User basis - rather than under the Local Machine hive in the Registry. Is this affecting you?

    A bit of a longshot: <!mskb=322374>Microsoft Knowledge Base Article 322374<!/mskb> mentions entering a DWORD value CommandLineSafe at the end of the Registering the COM Add-in Section. This is unlikely to affect you, but you might like to take a look at it.

    Hope This Helps
    Gre

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel com addin not loading at startup (Excel 2000)

    We developed it but I did forget to mention something abut the COM addin, it supports Word as well. First we developed the Excel designer and supporting code which works and then developed the designer and supporting code for Word which did work at first and then stopped. I have seen this happen on another COM addin that I have developed and then it fixes itself somehow, some sort of Microsoft magic I suppose.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel com addin not loading at startup (Excel

    Word COM Add-Ins behave slightly differently from the rest. There was an item I believe I saw on the Microsoft Newsgroups this morning - but did not pass on as you had not mentioned that Word was also involved. I am presently unable to re-locate it. You might try Searching there. The Add-ins Group - like the rest is accessible through Google on the Groups tab. (Click on the link when you get there.) HTH
    Gre

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel com addin not loading at startup (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Jim

    Can you rely on Microsoft Magic? I guess if the answer is Yes, then simply wait until it kicks in, and if the answer is No, well you better get to the bottom of this.

    I suppose you can try and make sure that the code works in each app independently, and then combine what you have into one COM add-in. Maybe do some checks as to what app is calling the COM functions, and determine what you need to do then.

    Did you try the suggestions given by the other Loungers?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel com addin not loading at startup (Excel 2000)

    I have tried them but no success as yet. Our installation engineer, the person who develops MSI installations using InstallShield DevStudio believes it may have something to do with the way regsvr32 registers COM Addins when the COM addin in question was once installed as self registering dll and then another time it isn't. She is basing some of that on the fact that on a clean PC( one that hasn't ever had the COM addin on it) we never see this problem whereas on non virgin PCs we see it sometimes.

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel com addin not loading at startup (Excel

    Each COM Add-in is dealt with entirely separately. From what you have been saying, you are dealing with separate COM Add-ins that are only being installed once. From what you report the installation engineer as saying, these are being installed more than once. Which is the case?

    Also, to eliminate a possible variable, are these COM Add-Ins being designed with DevStudio/Visual Studio version 6.0 or with the .NET version?
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •