borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (PLEASE HELP: Email Excel worksheet in body, not as an attachment)Next Topic (I wish my maths was better...) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Remove Add-In
Poster Message
~Bean~
Level: VB Guru


Registered: 07-04-2003
Posts: 488

icon Remove Add-In

Anyone know how to programmatically remove an Office Add-In from the avialable add-ins list?

(Excel)

____________________________
Eggheads unite! You have nothing to lose but your yolks.

17-04-2003 at 01:07 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
~Bean~
Level: VB Guru


Registered: 07-04-2003
Posts: 488
icon Re: Remove Add-In

has anyone actually tried to do this becuase it seems really assinine to me that MS put the .Add method in for the AddIns object but does not have a .Delete method...



____________________________
Eggheads unite! You have nothing to lose but your yolks.

25-04-2003 at 09:47 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
drshaw
Level: Guest

icon Re: Remove Add-In

Hi, have you tried this in code.

Application.AddIns.Item(INDEX NUMBER OF ITEM IN LIST).Delete

David  

17-06-2003 at 02:01 PM
| Quote Reply
~Bean~
Level: VB Guru


Registered: 07-04-2003
Posts: 488
icon Re: Remove Add-In

I have not tried that...because there is no "Delete" method...

but just to make sure I tried your code and it came up with the expected...

quote:
Runtime Error 438

Object doesn't support this property or method.




thx for the suggestion though...

____________________________
Eggheads unite! You have nothing to lose but your yolks.
17-06-2003 at 05:24 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Remove Add-In
Previous Topic (PLEASE HELP: Email Excel worksheet in body, not as an attachment)Next Topic (I wish my maths was better...) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder