Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Run-time error 429: ActiveX comonent can't create object" MSComm | Excel Programming | |||
"ActiveX component can't create object" | Excel Programming | |||
Error 429 ActiveX Component can't create object | Excel Programming | |||
ActiveX Error 429, "Can't create object" | Excel Programming | |||
error 429: ActiveX component can't create object | Excel Programming |