Opening XLL in VBA from Excel2003

G

Guest

Hi,
I'm trying to automatically open an XLL file from within vba. I have gone
about that in the following ways and all have failed for one reason or another
1.
Addins.Add(addinFullName).Installed = True

fails "Unable to get the Add property of the AddIns class"

2.
Set wb = Application.Workbooks.Open(addinFullName)
wb.RunAutoMacros 1

does not load/open anything

3. this is the best
Application.RegisterXLL addinFullName

worked the first time and from then on crashes Excel

My Excel is 2003 11.8117.8122 SP2
I have checked things like path and can manually open the XLL and everything
works fine..... if one of these 3 could just work....
Please help anyone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XLL Functions from Excel VBA 4
How Do I Use an XLL Add-In Function from Code? 1
XLL Internittently Fails to Load 0
Migrating from XLL to XLA 1
Location for DLL used by add-in (XLL) 2
Problem with Excel's COM interface in XLL 1
XLL Add-in help 1
VBA Workbooks.Open() / method 'open' of object 'workbooks' failed 0

Top