bdouglasoz
10-14-2008, 11:50 PM
Hi,
I've been using VBA for some time but have never worked with ActiveX controls.
I am trying to use an ActiveX Control that creates graphs (NTGraph3E) in Excel from a website called codeproject.com - the 3D Graph ActiveX Control.
I have registered the dll using REGSVR32.
I created an ActiveX control using the NTGraph3D class from the list.
I can see the empty x,y,z axis in the control.
I double-clicked on the control to add code.
I have ensured that I've ticked "NTGraph3D 1.0 Type Library" in my project References.
I can see the NTGraph3D objects when I open the object browser.
I have created the following test code:
Sub TstTorus()
Dim Gr As OLEObject
Dim WS As Worksheet
Set WS = Worksheets("Sheet1")
WS.OLEObject("NTGraph3D").ClearGraph
End Sub
I keep getting the same compile error:
Object library invalid or contains references to object definitions that could not be found.
Is there some step that I've missed? I would greatly appreciate help!:banghead:
bd
I've been using VBA for some time but have never worked with ActiveX controls.
I am trying to use an ActiveX Control that creates graphs (NTGraph3E) in Excel from a website called codeproject.com - the 3D Graph ActiveX Control.
I have registered the dll using REGSVR32.
I created an ActiveX control using the NTGraph3D class from the list.
I can see the empty x,y,z axis in the control.
I double-clicked on the control to add code.
I have ensured that I've ticked "NTGraph3D 1.0 Type Library" in my project References.
I can see the NTGraph3D objects when I open the object browser.
I have created the following test code:
Sub TstTorus()
Dim Gr As OLEObject
Dim WS As Worksheet
Set WS = Worksheets("Sheet1")
WS.OLEObject("NTGraph3D").ClearGraph
End Sub
I keep getting the same compile error:
Object library invalid or contains references to object definitions that could not be found.
Is there some step that I've missed? I would greatly appreciate help!:banghead:
bd