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

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

Jens.

--
http://ManagedXLL.net/
Replace MSDN with my first name when replying to my email address!



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

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

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


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