Starting add-in using vba
 

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

--
utm
-----------------------------------------------------------------------
utmb's Profile: http://www.excelforum.com/member.php...fo&userid=1609
View this thread: http://www.excelforum.com/showthread.php?threadid=27546

Starting add-in using vba
 

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.



"utmb" wrote in message
...

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

Thanks,


--
utmb
------------------------------------------------------------------------
utmb's Profile:
http://www.excelforum.com/member.php...o&userid=16099
View this thread: http://www.excelforum.com/showthread...hreadid=275469

Starting add-in using vba
 

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