Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Starting with a zero? | Excel Discussion (Misc queries) | |||
Postcodes starting with 0 | Excel Discussion (Misc queries) | |||
Starting over | Excel Programming | |||
Help with the basics. Starting out. | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |