Starting add-in using vba

[utmb]

For some reason this add-in won't stay loaded with excel 2003. M
computer was recently upgraded and now our IT dept. says that I wil
have to load it each time I start excel. (don't know why)

Thanks for your help, but the code didn't work.

Any other sugestions?

Thanks

 

[Jens Thiel]

Are you sure that you can succesfully load it through the Add-In manager,
and use functionality exported from this add-in? There can be other reasons
not related to Excel (e.g. missing DLLs).

To get some diagnostics, you can try running TraceXLL from our website (see
the forum link for a free download).

Jens.

 

[GS]

It would be helpful to show a sample of the code you are using to 'start' the
addin!

 

[keepITcool]

the threading is difficult on this one..


Your trying to install an addin..HOWEVER this is NOT an xla!

AddIns.Add Filename:="C:\Hyperion\Essbase\Bin\essexcln.xll"
AddIns("Hyperion Essbase OLAP Server DLL").Installed = True

I assume the 2nd line is to activate the addin installed with the first
line.


Note that AFAIK an XLL should be registered by:

Application.RegisterXLL <path>

you should NOT use the addins collections.

To see IF the XLL is registered you can test to see if a known function is
listed in the array called by Application.RegisteredFunctions



HTH



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


utmb wrote in message