Thread: Add-in removal
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Add-in removal



I am working on a VERY elaborate VBscript...:

checking if excel running.
done. with WMI!
reading registry entries.
done. enumming with WMI, reading with wscript.shell

checking files exist.
done: basic scanning for all installed/opened files found in
registry...
todo: checking on duplicate installs in various folders.
todo: checking for duplicate document titles...

(since document titles are used as unique index in the addins
collection, you cannot have 2 entries with the same title..

options to install/activate/uninstall done.
options to scan multiple excel versions. done.
options to open addins as readonly (/R parameter)

etc..

deciding which addins to remove or add...
deciding if and when to kill/rename/move files


Rebuilding the OPEN series under options...
That's a very minor problem.


IF and when I get it working I'll make sure I advertise it :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Hoffy wrote :

any suggestions of doing this automatically(scripted) since the open
value could be different on each persons machine and if you delete
OPEN1 and only have OPEN, OPEN 2, OPEN 3, etc only OPEN will get
loaded since it reads them sequentially.

"keepITcool" wrote:


Yes:
by deactivating the addin within the excel instance
THEN deleting the file.

OR if excel is NOT running by deleting
the OPENxxx value in the registry under

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options




--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam



Rob Hoffy wrote :

When I uninstall an add-in from excel by uninstalling the
application that install the add-in when launching excel after
the add-in has been removed excel says that it can't find the
add-in. Is there a way to do this so that the a user is not given
the error dialog?