VBA fails with Run-time Error 429 "ActiveX component can't create object"

E

EagleOne

XL 2007

Source File: MathNet.dll
Output file: MathNet.tlb

Included Classes MathNet.Division and MathNet.Multiplication
Functions DivideBy4(), DivideBy2(), MultiplyBy2(), MultiplyBy4()

After Visual Studio created a Visual Basic DLL (MathNet.dll) and (MathNet.tlb)
In Excel VBA IDE I entered the following code:

Sub TestDLL()

Dim Result As String
Dim MF As MathNET.Division 'Intellisense does display "Division"
Set MF = New MathNET.Division 'Fails w/Run-time Error 429 ActiveX component can't create object
Result = MF.DivideBy4(1234) 'Intellisense does display "DivideBy4"

End Sub

Need help to overcome the ActiveX error

Do I need to add a referrence? If not "Registered" how to do it?

TIA EagleOne
 
J

Joel

You need to add the MathNet.Dll and MathNet.tlb to the VBA references. go to
VBA menu tools - References and select browse. The window will automatically
be set for TLB and DLL file types.
 

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

"Run-time error 429: ActiveX comonent can't create object" MSComm 5
ActiveX component can't create object or return reference to thisobject (Error 429) 4
.net dll - error 429 ActivX component cannot create object 0
msWinSck.ocx: Run-Time Error 429 ActiveX Component can't create ob 5
Error 429 ActiveX Component can't create object 2
ActiveX Media Player Question 0
Run-time error '429' ActiveX component can't create object 0
Run-Time error 429 3

Top