View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Desaivres Alain Desaivres Alain is offline
external usenet poster
 
Posts: 23
Default Addin instalalltion throught a vbscript

In addition...

Assuming the file function.xla is already available in the default Addin
folder
If I run those lines in my script
Set appXL = CreateObject("Excel.Application")
appXL.Application.Addins.Add("addin.xla").Installe d = True

I get this error
Err.description: Unable to get the Add property of the AddIns class

Any idea ? Does it mean the Addin collection cannot b manipulated into
vbscript ?

Thanks
Alain