可以使用COM技术,在VB中直接操作AutoCAD,创建于VBA功能类似的程序,VB能够直接打包生成安装文件,这种形式比VBA更加方便,并且更容易保护自己的程序。VB连接到AutoCAD主要用到CreateObject和GetObject函数,创建或者获得对ActiveX对象的引用。
连接到AutoCAD之后,就可以使用acadApp对象对AutoCAD进行操作,语法和操作方法与VBA完全一致。
下面这段代码创建一个绘制楼梯剖面图的程序。
Dim bcal As Boolean
Dim ptarr1() As Double Dim ptarr2(19) As Double Private Sub cmdcal_Click() Dim objcontrol As Control For Each objcontrol In Form1.Controls If TypeOf objcontrol Is TextBox Then If objcontrol.Text = "" Then MsgBox "缺少参数,无法计算!", vbCritical Exit Sub End If End If Next Dim x0 As Double, y0 As Double Dim s As Double, t As Double, n As Double Dim b As Double, h As Double, h0 As Double x0 = txtptx.Text: y0 = txtpty.Text s = txtsteph.Text: t = txtstepw.Text: n = txtstepnum.Text b = txtgriderw.Text: h = txtgriderh.Text: h0 = txtboardt.Text If h0 >= h Or b > 80 Or s >= t Then MsgBox "输入条件不符合要求,请检查参数的合理性!", vbCritical Exit Sub End If ReDim ptarr1(2 * (2 * n + 2) - 1) ptarr1(0) = x0 - 100: ptarr1(1) = y0 ptarr1(2) = x0: ptarr1(3) = y0 ptarr1(4) = x0: ptarr1(5) = y0 + s Dim i As Integer For i = 6 To 2 * (2 * n + 2) - 3 If i Mod 4 = 2 Then ptarr1(i) = ptarr1(i - 4) + t ElseIf i Mod 4 = 3 Then ptarr1(i) = ptarr1(i - 4) + s ElseIf i Mod 4 = 0 Then ptarr1(i) = ptarr1(i - 2) ElseIf i Mod 4 = 1 Then ptarr1(i) = ptarr1(i - 2) + s End If Next i ptarr1(2 * (2 * n + 2) - 2) = ptarr1(2 * (2 * n + 2) - 4) + 100 ptarr1(2 * (2 * n + 2) - 1) = ptarr1(2 * (2 * n + 2) - 3) ptarr2(0) = x0 - 100: ptarr2(1) = y0 - h0 ptarr2(2) = x0 - b: ptarr2(3) = y0 - h0 ptarr2(4) = x0 - b: ptarr2(5) = y0 - h ptarr2(6) = x0: ptarr2(7) = y0 - h ptarr2(8) = x0: ptarr2(9) = y0 - h0 ptarr2(10) = x0 + (n - 1) * t: ptarr2(11) = y0 + (n - 1) * s - h0 ptarr2(12) = ptarr1(2 * (2 * n + 2) - 4): ptarr2(13) = ptarr1(2 * (2 * n + 2) - 3) - h ptarr2(14) = ptarr2(12) + b: ptarr2(15) = ptarr2(13) ptarr2(16) = ptarr2(14): ptarr2(17) = ptarr2(15) + (h - h0) ptarr2(18) = ptarr1(2 * (2 * n + 2) - 2): ptarr2(19) = ptarr1(2 * (2 * n + 2) - 1) - h0 bcal = True End Sub Private Sub cmddraw_Click() If bcal = False Then MsgBox "请先进行计算,再进行绘图!", vbCritical Exit Sub End If On Error Resume Next Dim acadapp As AcadApplication Set acadapp = GetObject(, "AutoCAD.Application.16") If Err Then Err.Clear 'MsgBox "sssssssssssss" 'Set acadapp = CreatObject("AutoCAD.Application.16") If Err Then MsgBox Err.Description Exit Sub End If End If Dim acaddoc As AcadDocument Set acaddoc = acadapp.ActiveDocument acaddoc.ModelSpace.AddLightWeightPolyline ptarr1 acaddoc.ModelSpace.AddLightWeightPolyline ptarr2 ZoomAll acadapp.Visible = True bcal = False End Sub Private Sub cmdexit_Click() End End Sub Private Sub Form_Load() txtptx.Text = 0 txtpty.Text = 0 txtptz.Text = 0 txtsteph.Text = 20 txtstepw.Text = 40 txtstepnum.Text = 10 txtgriderw.Text = 25 txtgriderh.Text = 45 txtboardt.Text = 15 bcal = False End Sub
因为VB和AutoCAD之间是通过COM技术连接,这种数据交换对系统资源的消耗很大,同样的计算在VB运算消耗的时间比在VBA中的运算时间要多5倍以上,在VB中按F5键运行程序,可以在Form中对楼梯参数进行设置,就可在CAD中绘制楼梯剖面图。创建VB程序时要尽可能减少程序和AutoCAD之间的数据交换,所有计算尽量在VB中完成,直接传递给AutoCAD计算结果,使CAD可以直接根据结果进行绘图。在VB中按下F5键,单击绘图按钮即可在CAD中看到绘制的楼梯剖面图。