ClipboardRectangle.bas 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. '// Attribute VB_Name = "剪贴板尺寸建立矩形"
  2. Type Coordinate
  3. x As Double
  4. y As Double
  5. End Type
  6. Public O_O As Coordinate
  7. Sub start()
  8. '// 坐标原点
  9. O_O.x = 0: O_O.y = 0
  10. Dim ost As ShapeRange
  11. Set ost = ActiveSelectionRange
  12. O_O.x = ost.LeftX
  13. O_O.y = ost.BottomY - 50 '选择物件 下移动 50mm
  14. '// 建立矩形 Width x Height 单位 mm
  15. ' Rectangle 101, 151
  16. Dim Str, arr, n
  17. Str = GetClipBoardString
  18. ' 替换 mm x * 换行 TAB 为空格
  19. Str = VBA.Replace(Str, "mm", " ")
  20. Str = VBA.Replace(Str, "x", " ")
  21. Str = VBA.Replace(Str, "*", " ")
  22. Str = VBA.Replace(Str, Chr(13), " ")
  23. Str = VBA.Replace(Str, Chr(9), " ")
  24. Do While InStr(Str, " ") '多个空格换成一个空格
  25. Str = VBA.Replace(Str, " ", " ")
  26. Loop
  27. arr = Split(Str)
  28. Dim x As Double
  29. Dim y As Double
  30. For n = LBound(arr) To UBound(arr) - 1 Step 2
  31. ' MsgBox arr(n)
  32. x = Val(arr(n))
  33. y = Val(arr(n + 1))
  34. If x > 0 And y > 0 Then
  35. Rectangle x, y
  36. O_O.x = O_O.x + x + 30
  37. End If
  38. Next
  39. End Sub
  40. Private Function Rectangle(Width As Double, Height As Double)
  41. ActiveDocument.Unit = cdrMillimeter
  42. Dim size As Shape
  43. Dim d As Document
  44. Dim s1 As Shape
  45. '// 建立矩形 Width x Height 单位 mm
  46. Set s1 = ActiveLayer.CreateRectangle(O_O.x, O_O.y, O_O.x + Width, O_O.y - Height)
  47. '// 填充颜色无,轮廓颜色 K100,线条粗细0.3mm
  48. s1.Fill.ApplyNoFill
  49. s1.Outline.SetProperties 0.3, OutlineStyles(0), CreateCMYKColor(0, 100, 0, 0), ArrowHeads(0), ArrowHeads(0), cdrFalse, cdrFalse, cdrOutlineButtLineCaps, cdrOutlineMiterLineJoin, 0#, 100, MiterLimit:=5#
  50. sw = s1.SizeWidth
  51. sh = s1.SizeHeight
  52. Text = Trim(Str(sw)) + "x" + Trim(Str(sh)) + "mm"
  53. Set d = ActiveDocument
  54. Set size = d.ActiveLayer.CreateArtisticText(O_O.x + sw / 2 - 25, O_O.y + 10, Text) '// O_O.y + 10 标注尺寸上移 10mm
  55. size.Fill.UniformColor.CMYKAssign 0, 100, 100, 0
  56. End Function
  57. Private Function setRectangle(Width As Double, Height As Double)
  58. Dim s1 As Shape
  59. Set s1 = ActiveSelection
  60. ActiveDocument.Unit = cdrMillimeter
  61. '// 物件中心基准, 先把宽度设定为
  62. ActiveDocument.ReferencePoint = cdrCenter
  63. s1.SetSize Height, Height
  64. '// 物件旋转 30度,轮廓线1mm ,轮廓颜色 M100Y100
  65. s1.Rotate 30#
  66. s1.Outline.SetProperties 1#
  67. s1.Outline.SetProperties Color:=CreateCMYKColor(0, 100, 100, 0)
  68. End Function
  69. Private Function GetClipBoardString() As String
  70. On Error Resume Next
  71. Dim MyData As New DataObject
  72. GetClipBoardString = ""
  73. MyData.GetFromClipboard
  74. GetClipBoardString = MyData.GetText
  75. Set MyData = Nothing
  76. End Function