Indecent Add-in Exposure

Every so often, for reasons I can’t explain, an add-in shows up in my Excel UI.

addinshowingup

Today it was BlogHelpers.xla, but other times it’s different. It’s always in a non-maximized window view. That is, the workbook name is in the window’s title bar and not the application’s title bar. You can see that the IsAddin property is still True. If I close the UI window, the Add-in remains in the VBE projects window. But I’m too chicken to leave it in that state for long, so I always reboot.

Have you ever seen that before?

6 Comments

  1. snb says:

    What is it’s fullname ?

  2. Dick Kusleika says:

    Like this?

    ?thisworkbook.FullName
    C:\Users\dkusleika\AppData\Roaming\Microsoft\AddIns\BlogHelpers.xla
  3. snb says:

    What I can come up with:

    - There’s a link to the addin in the startupdirectory
    - There’s some code in the personal.xlsb workbook codemodule
    - The addin is part of a workspace that is being loaded.
    - somewhere ‘addins(j).installed = true’ is being run

  4. Ross says:

    Are they always .xla’s??

  5. Dick Kusleika says:

    Here’s some sketchy info:

    It doesn’t happen on startup. I *think* it happens when I close a workbook, but I can’t be sure of that.
    I thought it might be only xlas, but I *think* I remember it happening an xlam.
    I have 11 of my own add-ins running, four of which are xlam
    I don’t have a PMW
    I’ve never used a workspace

    After the last time it happened I (obviously) took a picture. But I also decided to take note of what I’m doing when it happens again. Of course it hasn’t happened again and probably never will – but I’d be OK with that.

  6. ross says:

    No idea really, shame it does not happen all the time then you would have to sort it out.
    Might well be some sort of loading issue, I mean like the code is accessing some contested resource or something – it must be something what only happen when xyz conditions are mate – like memory use is high, or disk busy, or cpu hot, something that doesn’t happen that often… well of you laptop anyway ;-). Odd.

    Maybe clean out all the reg keys and re load the addins? I have no idea really.

    I get issue loading addins a fair bit, but I put it down to developing the same file across 2 different versions of 2007? maybe!

Posting code or formulas in your comment? Use <code> tags!

  • <code lang="vb">Block of code goes here</code>
  • <code lang="vb" inline="true">Inline code goes here</code>
  • <code>Formula goes here</code>

Leave a Reply

You must be logged in to post a comment.

Here's how to update your reports of company and nearly any web data: