View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default change path to an add-in

It might not be not straightforward. If the addin originally was not in one
of the default library paths it'll be difficult to remove it from the addins
collection, after say uninstalling it and moving it (Name..As) to a
different folder. You'd be able to "apparently" add it back to the addins
collection but probably won't "install". No problems though if you rename
the addin after moving it, and ideally its title after first reloading as a
workbook. Might need to do it all in two sessions, first uninstall and move,
second session re-install

A better approach would be to amend the path in the OPENx key in the
registry (which can be done programmatically) along similar lines to an
installer.

Another thing you may need to do is update links in any wb that has the
addin's udf's in formulas.

It's a bit vague though as to what you are trying to do, what have you
attempted to do.

Regards,
Peter T


"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