ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unload an addin (https://www.excelbanter.com/excel-programming/355724-unload-addin.html)

Thierry Paradis

Unload an addin
 
Hi!

To uninstall an add-in, i'm using a .vbs script. My problem is when Excel is
open and i try to "uninstall" the addin, i get an Access Denied error.
objXL.AddIns("LMI!Comptable").Installed = False

I think there's two ways to resolve my problem:

1- unload the add-in (possible?!?!?)
2-Check if Excel is open (possible?!??) and launch a warning to close it

What would be the better solution and how can we do this?

Thanks,

Thierry Paradis.



davesexcel[_58_]

Unload an addin
 

Can you not go to my computer and delete the file,

or in excel go to tools options and uncheck the add-in


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521260


HS Hartkamp[_2_]

Unload an addin
 

In VBA I would use
workbooks("autosave.xla").Close

Isn't there some equivalent of that in vbs ?

Bas Hartkamp


"Thierry Paradis" schreef in bericht
...
Hi!

To uninstall an add-in, i'm using a .vbs script. My problem is when Excel
is open and i try to "uninstall" the addin, i get an Access Denied error.
objXL.AddIns("LMI!Comptable").Installed = False

I think there's two ways to resolve my problem:

1- unload the add-in (possible?!?!?)
2-Check if Excel is open (possible?!??) and launch a warning to close it

What would be the better solution and how can we do this?

Thanks,

Thierry Paradis.






All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com