|
楼主 |
发表于 2022-10-5 01:51
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
tang 兄:还好,最近我保存了一些历史版本。在 9月30日 的版本中找到了 2345 个选项对齐的宏。
sylun 兄:像示例文档中有两个不可见字符,我觉得不清除也可以,无非就是多占几行。
今晚,我又折腾了一下《公文排版、普通排版、条文排版》三个宏,前两个默认段后一行,后者段后空段。
- Sub OptionAlign()
- '选项对齐
- Dim t As Table, i As Paragraph, TableWidth!, oTab!, Tab1!, Tab2!, Tab3!, Tab4!, OptionNum&
- With ActiveDocument
- .Tables.Add .Range(0, 0), 1, 1
- TableWidth = Round(.Tables(1).Cell(1, 1).Width / 28.35, 2)
- .Tables(1).Delete
- .Content.Find.Execute "^l", , , 0, , , , , , "^p", 2
- For Each t In .Tables
- With t.Range.Rows
- .WrapAroundText = False
- .Alignment = wdAlignRowCenter
- End With
- Next
- With .Content.Find
- .Execute "(^13)([ ^s^t]{1,})", , , 1, , , , , , "\1", 2
- .Execute "([ ^s^t]{1,})(^13)", , , 1, , , , , , "\2", 2
- .Execute "([A-E])[.、]", , , 1, , , , , , "\1.", 2
- .Execute "([ ^s^t^13]{1,})([B-E].)", , , 1, , , , , , "\2", 2
- .Execute "(^13)([0-9]{1,})[.、]", , , 1, , , , , , "\1\2.", 2
- .Execute "([B-E].)", , , 1, , , , , , "^t\1", 2
- End With
- For Each i In .Paragraphs
- With i.Range
- If Not .Information(12) Then
- If .Text Like "A.*" Then
- With .Font
- If .ColorIndex = wdRed Then .ColorIndex = wdBlue Else .ColorIndex = wdRed
- .Bold = wdToggle
- End With
- If .Text Like "A.*B.*C.*D.*E.*" Then
- OptionNum = 5
- GoSub op
- With .ParagraphFormat.TabStops
- .ClearAll
- .Add Position:=CentimetersToPoints(Tab1)
- .Add Position:=CentimetersToPoints(Tab2)
- .Add Position:=CentimetersToPoints(Tab3)
- .Add Position:=CentimetersToPoints(Tab4)
- End With
- 'cut
- If .ComputeStatistics(1) = 2 Then
- .Find.Execute "^t([CE].)", , , 1, , , , , , "^p\1", 2
- End If
- ElseIf .Text Like "A.*B.*C.*D.*" Then
- OptionNum = 4
- GoSub op
- With .ParagraphFormat.TabStops
- .ClearAll
- .Add Position:=CentimetersToPoints(Tab1)
- .Add Position:=CentimetersToPoints(Tab2)
- .Add Position:=CentimetersToPoints(Tab3)
- End With
- ' 'cut
- If .ComputeStatistics(1) = 2 Or .ComputeStatistics(1) = 3 Then
- .Find.Execute "^t(C.)", , , 1, , , , , , "^p\1", 2
- ElseIf .ComputeStatistics(1) = 4 Then
- .Find.Execute "^t([BD].)", , , 1, , , , , , "^p\1", 2
- End If
- 'cuts
- If .ComputeStatistics(1) = 2 Then
- With .ParagraphFormat.TabStops
- .ClearAll
- .Add Position:=CentimetersToPoints(Tab2)
- End With
- ElseIf .ComputeStatistics(1) = 4 Then
- .Find.Execute "^t([B-D].)", , , 1, , , , , , "^p\1", 2
- End If
- ElseIf .Text Like "A.*B.*C.*" Then
- OptionNum = 3
- GoSub op
- With .ParagraphFormat.TabStops
- .ClearAll
- .Add Position:=CentimetersToPoints(Tab1)
- .Add Position:=CentimetersToPoints(Tab2)
- End With
- 'cut
- If .ComputeStatistics(1) = 2 Then
- .Find.Execute "^t([BC].)", , , 1, , , , , , "^p\1", 2
- End If
- ElseIf .Text Like "A.*B.*" Then
- OptionNum = 2
- GoSub op
- With .ParagraphFormat.TabStops
- .ClearAll
- .Add Position:=CentimetersToPoints(Tab1)
- End With
- End If
- With .ParagraphFormat
- .CharacterUnitFirstLineIndent = 0
- .FirstLineIndent = CentimetersToPoints(0)
- .CharacterUnitLeftIndent = 0
- .LeftIndent = CentimetersToPoints(0)
- .CharacterUnitRightIndent = 0
- .RightIndent = CentimetersToPoints(0)
- .CharacterUnitFirstLineIndent = 2
- End With
- End If
- End If
- End With
- Next
- End With
- Exit Sub
- op:
- If OptionNum = 4 Then
- oTab = (Int((TableWidth - 2 * 0.19) * 2.7 + 0.5) - 2) / 4
- Tab1 = Round((2 + 1 * oTab) / 2.7, 2)
- Tab2 = Round((2 + 2 * oTab) / 2.7, 2)
- Tab3 = Round((2 + 3 * oTab) / 2.7, 2)
- ElseIf OptionNum = 3 Then
- oTab = (Int((TableWidth - 2 * 0.19) * 2.7 + 0.5) - 2) / 3
- Tab1 = Round((2 + 1 * oTab) / 2.7, 2)
- Tab2 = Round((2 + 2 * oTab) / 2.7, 2)
- ElseIf OptionNum = 2 Then
- oTab = (Int((TableWidth - 2 * 0.19) * 2.7 + 0.5) - 2) / 2
- Tab1 = Round((2 + 1 * oTab) / 2.7, 2)
- ElseIf OptionNum = 5 Then
- oTab = (Int((TableWidth - 2 * 0.19) * 2.7 + 0.5) - 2) / 5
- Tab1 = Round((2 + 1 * oTab) / 2.7, 2)
- Tab2 = Round((2 + 2 * oTab) / 2.7, 2)
- Tab3 = Round((2 + 3 * oTab) / 2.7, 2)
- Tab4 = Round((2 + 4 * oTab) / 2.7, 2)
- End If
- Return
- 'cm=char/2.7
- End Sub
复制代码 |
|