vba move and addin from %appdata% to c:\mymdl\

in excel 2003 there is no way to delete an addin with vba, you can only uninstall it which leaves it loaded.

But, is there some way to move the location?  

I have spent about 2 hours trying the obvious things, and none of them work.

For instance, I tried closing the addin and reopening it the correct location.  It works fine, but when I close excel entirely and reopen it, it goes back to its original location.  

I have 10 workstations where we need to do this, so I need a vba solution.

LVL 5
rberkeConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
A "removed" (uninstalled) Add-in reference *is* unloaded; the collection of Add-ins within the list shown is only updated when you manually open the "Tools" / "Add-Ins..." dialog box & click the check-box beside the previously uninstalled Add-in name.

The associated file is then (re-)checked & you are prompted to remove the entry from the list shown if the file is not found.

You may, however, be able to remove entries from the appropriate Windows Registry settings key(s) via Visual Basic for Applications code, but this may have to be performed externally to MS-Excel in case closing the local user's MS-Excel session re-writes the Registry entries (reinstating the entry or entries you have just removed programmatically).

BFN,

fp.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rberkeConsultantAuthor Commented:
To summarize your comment "It is (nearly) impossible for vba to remove an addin from the list.  But it es easy to do it manually."

So, I went to all 10 workstations and did it manually.  It only took 20 minutes (including the time I spent chatting with the users.)

The reinstall of the addin in a new location could have been entirely automated by putting ...addins.add and associated  code into the open event associated with an xlstart workbook .

But, I have chosen a different route which is beyond the scope of this question.
0
[ fanpages ]IT Services ConsultantCommented:
Thanks for your follow-up comment.

Yes, I concur with your summary :)

The level of impossibility is directly proportional to the amount of time you have for unlimited monkeys & typewriters at your disposal.

Sometimes it just takes longer to automate "one-off" solutions than manually performing the same tasks.

That said, the tools/functionality provided my Microsoft Excel are far from ideal.

Good luck with your project.

BFN,

fp.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.