Question

Excel VBA调用CAD2007画图并显示

调用的时候,有的时候可以打开,有的时候就卡住不动了,哪位高手会啊?
代码如下:
Sub Cad_drawing()
Dim App As AcadApplication, DOC As AcadDocument
On Error Resume Next
Set App = GetObject(, "AutoCad.Application") '若AutoCAD 已运行则获得它的对象实例
If Err Then '若没有安装 AutoCAD
Err.Clear
Set App = CreateObject("AutoCad.Application")
If Err Then '若没有安装 AutoCAD
MsgBoxErr.Description
MsgBox "系统未安装AutoCAD,请安装AutoCAD"

End If
End If
App.Visible = True
Set DOC = App.Documents.Add
......
中间是画图的指令
......
App.ActiveDocument.SaveAs "D:\线路纵断面图.dwg"
App.Application.ZoomExtents
End Sub

我是新手,所以编的比较简单,望高手帮忙解决问题

Answer 1

我这里提供一个函数，是连接获取cad（2004版，其他差不多）
Private Function ConnectToCAD2004() As Boolean
'连接AUTO CAD 2004
On Error Resume Next
Set acadApp = GetObject(, "autocad.application.16")
If Err Then
Err.Clear
Set acadApp = CreateObject("autocad.application.16")
If Err Then
ConnectToCAD2004 = False
MsgBox "连接Auto CAD 2004没有成功!" & vbNewLine & "请确认安装的版本。或手动打开Auto CAD 2004，然后点击连接按钮。" _
& vbNewLine & vbNewLine & Err.Description, vbInformation, AppName
Exit Function
End If
End If
On Error GoTo 0
'获取Auto CAD 2004当前文档
On Error Resume Next
Set acadDoc = acadApp.ActiveDocument
If Err.number <> 0 Then
ConnectToCAD2004 = False
MsgBox "Auto CAD 2004中没有活动的文档。" _
& "请激活一个文档或新建一个文档。", vbInformation, AppName
Err.Clear
Exit Function
End If
ConnectToCAD2004 = True
acadApp.Visible = True
End Function

需要全局变量或者模块及变量：
Public Const AppName = "----------------"
Public acadApp As AcadApplication
Public acadDoc As AcadDocument

每次执行画图之前：调用函数即可：
'连接CAD2004
If ConnectToCAD2004 = False Then
Exit Sub
End If

Answer 2

关机从开机