How do I find out what folder an addin in excel is pointing to? 1

[kippy13]

Hi,
I have recently come across a query from an excel user with in our office. He wants to know how to check where excel is taking the addin from.
Its hard to explain. Basically when you want excel to use an addin, you go to tools>addins browse to where the addin is then click the box beside the addin.
How do we check where a clicked addin is taking the addin from?

I would appreciate any help.
Kippy13

 

[Hasit]

In the main, these add-ins are found here:

\Program Files\Microsoft Office\Office\Library

However, in the Add-ins manager (TOOLS->ADD-INS), you can click on browse and find any .xla file, point to it from any folder/directory and add the new add-in that way.

Therefore, if you decide you want an add-in located in say "My Documents" folder, then you can add it to the list of add-ins from the add-ins manager.

 

[kippy13]

Thanks Hasit,
There are a few things which I need maybe to explain more.
Basically we are doing a software upgrade. The location of the old addin was in another folder while the new addin of the same name is to be located in the library folder.
When we rename the old addin and point the tools addins to the new folder and restart excel, excel looks for the old addin(we think). We need to make sure that the addin is looking in the library folder and is not effected by the old addin(for whenever we are doing automatic updates).
We just need to see where the current addin is pointing to. As far as I can see this is not possible.

 

[Hasit]

You are correct that it is not possible to "see" where the add-ins are looked for.

However, if you run REGEDIT from the command dialogue box (BE VERY CAREFUL NOT TO MAKE CHANGES!) then you can search for ADD-IN and it will show you the full path(s) of where ADD-IN manager is looking for the add-ins.

HTH.

 

[acron]

Try the following bit of VBA, which should show the AddIns path and if they are installed currently.

Dim xlAddIn As Excel.AddIn
    For Each xlAddIn In Excel.AddIns
        Debug.Print xlAddIn.FullName, xlAddIn.Installed
    Next

A.C.