LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Removing Add-ins programmatically from Excel 2003 using VBScript

I have a small VBScript that uses Excel Automation Server to install [and
update] an XLA file. Within the same package, I also provide an UnInstall
routine.

I have 2 problems:

1) To get rid of the XLA, I cannot use "Application.AddIns.Remove(<ref)"
*since this method is unknown to VBA* but I have to issue an
"Application.AddIns(<ref).Installed = False" first and then, after I quit
Excel Automation server, to physically delete the file. After that, the
Add-In does not load anymore but it still appears in my Add-Ins list; Excel
will delete it only after I click on the 'invalid' entry. Is there a way
(without going thru the registry) to really get rid of Add-Ins
programmatically?

2) If I issue an "Application.AddIns(<ref).Installed = False" and next
issue an "Application.AddIns.Add" with the same XLA but from a different
folder, Excel continues to link the first one. Is there a way to update the
Add-ins programmatically so that I link the right one?

I have seen that Excel continues to swap Add-ins from the registry key
"HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Options" for those
loaded and installed ('OPEN', 'OPEN1', 'OPEN2', ...) the key
"HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Excel\Add-in Manager" for
those loaded but not installed (using the internal name of the Add-in, for
instance 'My Addin').

Could not find any relevant info on MSDN/Microsoft.

Help needed
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotals Deleting Rows after removing Subtotal - 2003 Excel Raul[_2_] Excel Worksheet Functions 1 October 2nd 07 06:28 PM
Removing custom toolbar from Excel 2003 [email protected] Excel Discussion (Misc queries) 0 July 14th 06 05:00 PM
Using Excel 2003 SP1 - Removing a VBA module closes Excel Greg on DBear Excel Programming 0 May 30th 05 12:04 PM
Programmatically inserting a row with Excel 2003 stonequest Excel Programming 4 May 3rd 04 11:58 AM
Removing Checkboxes Programmatically Mark D'Agosta Excel Programming 4 October 21st 03 03:57 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"