Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
force addins.add to change folder for an addin
you'd need to delete the registry settings - not difficult to do, but
everytime Excel closes it updates these settings. So this is quite tricky. Run Regedit and and look in KKEY_CURRENT_USER / Software / Microsoft / Office / 10.0 / Excel / Options you wil see names like 'OPEN','OPEN1' ...'OPENnn' where each addin is listed. Delete any you don't want. Open Excel, check the add-in manager, select an add-in the go back to the worksheet, close excel and rexamine the registry again. We haev done considerable work on this and to "guarantee" our custom add-ins load correctly, we clean the registry, add our components to it and then excel is ready to open. tedious, but we run bit of VB so its fast, seemless and painless! Hope this helps "Brian Murphy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addins-Slow loading of each individual Addin using Excel 2007 | Excel Discussion (Misc queries) | |||
how can i change my default working folder to a networked folder? | Excel Discussion (Misc queries) | |||
Force a Readonly Workbook to save to a different folder | Excel Discussion (Misc queries) | |||
Excel addins disappearing from addin manager | Excel Discussion (Misc queries) | |||
Addins - Is it necessary to duplicate changes in both the VBAProject AND the Addin | Excel Programming |