View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default change path to an add-in

Brian -

You need to uninstall the add-in, then add and install the add-in from the
new location:

AddIns("My Add-In").Installed = False
Set myAddIn = AddIns.Add(Filename:="C:\New Path\MYADDIN.XLA")

AddIns("My Add-In").Installed = True

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Murphy" wrote in message
...
If an xla add-in has been installed from folder A to the add-ins
collection, and I want to redirect it to another folder B, can this be
done from VBA?

Thanks,

Brian Murphy