View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default 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