|
- 以下为一段excel vba代码,其功能是根据输入的坐标值,将预先定义好的勘探点类型(图块)以及孔号展到CAD图中,现在有一个问题就是,展点的时候如何实现图块或者孔号在CAD中根据我的要求旋转一定的角度?求高手指教!
- Sub 宏2()
- ' 展孔标志(含类别)
- ' 快捷键: Ctrl+a
- '
- Dim m, n, i, j, k, l, o, p As Integer
- n = Cells(3, 4)
- For i = 3 To n * 6 - 3 Step 6
- Cells(i, 1) = "-insert"
- Next i
-
- k = 4
- For j = 4 To n * 6 - 2 Step 6
- Cells(j, 1) = Cells(k, 11)
- k = k + 1
- Next j
-
- l = 4
- For m = 5 To n * 6 - 1 Step 6
- Cells(m, 1) = Cells(l, 4)
- l = l + 1
- Next m
-
- For o = 6 To n * 6 Step 6
- Cells(o, 1) = Cells(1, 4)
- Cells(o + 1, 1) = Cells(1, 4)
- Cells(o + 2, 1) = 0
- Next o
-
- Range(Cells(3, 1), Cells(6 * (n - 1) + 4 + 4, 1)).Select
- Selection.Copy
- End Sub
- Sub 宏3()
- ' 展孔号
- ' 快捷键: Ctrl+b
- '
- Dim m, n, i, j, k, l, o, p As Integer
- n = Cells(3, 4)
-
- For i = 3 To n * 6 - 3 Step 6
- Cells(i, 2) = "dtext"
- Next i
-
- k = 4
- For j = 4 To n * 6 - 2 Step 6
- Cells(j, 2) = Cells(k, 4)
- k = k + 1
- Next j
-
- l = 4
- For m = 5 To n * 6 - 1 Step 6
- Cells(m, 2) = Cells(2, 4)
- l = l + 1
- Next m
-
- p = 4
- For o = 6 To n * 6 Step 6
- Cells(o, 2) = 0
- Cells(o + 1, 2) = Cells(p, 5)
- p = p + 1
- Next o
-
- Range(Cells(3, 2), Cells(6 * (n - 1) + 4 + 4, 2)).Select
- Selection.Copy
- End Sub
- Sub 宏4()
- ' 展孔标志(不含类别)
- ' 快捷键: Ctrl+c
- Dim m, n, i, j, k, l, o, p As Integer
- n = Cells(3, 4)
-
- For i = 3 To n * 6 - 3 Step 6
- Cells(i, 3) = "circle"
- Next i
-
- k = 4
- For j = 4 To n * 6 - 2 Step 6
- Cells(j, 3) = Cells(k, 4)
- k = k + 1
- Next j
-
- For m = 5 To n * 6 - 1 Step 6
- Cells(m, 3) = Cells(1, 4)
- Next m
-
- Range(Cells(3, 3), Cells(6 * (n - 1) + 4 + 1, 3)).Select
- Selection.Copy
- End Sub
复制代码
|
|