?
Solved

Remote Microsoft Excel Add-in

Posted on 2013-05-30
5
Medium Priority
?
938 Views
Last Modified: 2013-07-06
I have an "unsupported" add-in that was loaded to a users computer from Kareo.  When I say unsupported that means that they only support it if the add-in works.

I was able to do a test install onto a system that is running same OS and Save version of Office.

Here is my dilemma --

First it was installed on a system (os / version same as above) incorrectly.

so the add-in show's up in Add-Ins on Excel.  When we try to execute any of the add-in menu driven commands it fails says cannot find kareo%20...blah blah blah.xls maybe is has been removed or deleted.

So on the test system the add-in was added successfully the correct way, and it works.  On the system with the problem we attempted to re-add the add-in from a general location and went through the setup and all seemed to work the first time.

Now after closing excel and re-opening the add-in appears to be calling the first add-in that was loaded incorrectly.  We get the same error message that we received above.  So my thoughts are somehow I need to completely remove that add-in from previous install ...

I have no references to it in the registry
the only option on excel add-ins is to uncheck the box, but it is the same name as the new add-in and unchecking the box does nothing, still have the add-in menu on the add-in toolbar.

How can I remove this add-in?  

also to get the new add-in to work I had to modify the macros or code from references to DOMDocument to DOMDocument60 (adding 60 to any parts of the code that failed.)  This works well on my test system...  

PS.. I am not a coder so don't understand it 100%

Any help is appreciated.

If my description of problem is bad or incomplete I apologize.  Please feel free to ask me to clarify anything.  I have attached a picture of the error and the menu that show's up in both working and non-working deployment (it's the same in either).
Please help.
kareoError.PNG
kareomenu.PNG
kareomenu2.PNG
0
Comment
Question by:halejr1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Faustulus
ID: 39209771
To remove an add-in from your computer it may be best to delete the file. There is a default location for add-ins. On Excel 2010 it might be C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. If you don't run Excel 2010 or you don't file your workbook there you can search for the file name on your C-drive. You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
After you delete the workbook the Add-in will still be listed. Restart Excel. If Excel tries to load it you will be informed that it wasn't found. If not, load it manually from the Add-ins list, where it still appears. Excel will ask you if you wish to delete it. Click yes, and it will be finally gone.
You can use the reverse process to install an Add-in. Place it in the default file location (with the correct extension, xla*), Developer tab -> Addins -> Browse, and select it.
The most important thing is to remember to restart Excel after deleting addin workbooks in the directory before placing files there with the same name, even if the extension is different.
I hope this helps you solve the problem.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39209881
thank you I will try this tonight and if success award you points.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39220374
did not resolve issue.  I have deleted all references to the file including shortcuts... gone as far as searching the registry, etc.  

System still show's the add-in and when selected get the associated error message.

Any other thoughts or idea's?

Thanks.
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 1500 total points
ID: 39220567
Did you find the add-in file?
It should be in C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. There is no need to go into the registry.
Have you located the default file location your Excel setup is using? It should be at the above address but, since you have a problem, it will be better to check it in the way I told you last time:-
You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
The problem will not go away unless you find and delete the file and then restart Excel.
0
 
LVL 8

Author Closing Comment

by:halejr1
ID: 39304200
this did not solve my issue but was very good advice.  I had to create a new profile and all was good.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question