Starting add-in using vba

[utmb]

I have an add-in that I have to load everytime I ope
excel,"essexcln.xll.

I have tried to write a macro to load this add-in but I keep getting a
error message. Can someone please help me with this.

My vba book has some sample coding that I have been trying it is a
follows


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

Thanks

 

[Jim May]

Add-in (I thought??) were normally filename.xla << ext xla the "a" for
addin;
Anyway other than that (problem maybe..)
If you need to load this add-in each time you open Excel
the intended manner to do this is to do it only once -- by going to your
tools menu,
selecting add-ins , then browse... find and click on (normally)
essexcln.xla ,, OK.
Close and Reopen Excel.

 

[Jens Thiel]

Use the tools > add-in manager to add the XLL, or run the following code:

Application.RegisterXLL("C:\Hyperion\Essbase\Bin\essexcln.xll")

Jens.