Unload an addin

[Thierry Paradis]

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.

[HS Hartkamp]

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

Isn't there some equivalent of that in vbs ?

Bas Hartkamp


"Thierry Paradis" <[email protected]> schreef in bericht
news:%[email protected]...
> 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.
>