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

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

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

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.



" wrote:

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