excel 2010 control of Autocad

[tuli01]

Hello,

I am using Microsoft Office 2010 and in the excel VBA I am trying to open a new autocad session. It does not work. Is there a mistake or Excel 2010 cannot do the same job excel 2003 did.
The error I get is: User-defined type not defined
Please advise

Thank you

Here is the module:

Public Sub TACAD()

Dim AcadApp As AcadApplication
Dim MyDwg As AcadDocument
Dim DWG As String ' file path

Set AcadApp = GetObject(, "AutoCAD.Application")


End Sub

 

[TCARPENTER]

Sound like you need to add a reference to the AutoCAD type libraries...

HTH
Todd