View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Murphy Brian Murphy is offline
external usenet poster
 
Posts: 126
Default force addins.add to change folder for an addin

Hello Excellers,

I'm trying to make an addin be auto-installing when it is opened.

The addin's "installed" property is false so it does not get opened when excel starts up.

If the addin is already installed in one folder, but is now being opened from second folder, I try to use Addins.Add with the full pathname of the new folder.

This seems to get done without error, but the folder for the addin does not actually get changed. As evidenced by closing and reopening excel, and finding that the addin is still being pointed to in the first folder.

Is there some way to force the folder change to take place?

Thanks,

Brian Murphy
Austin, Texas