增加空行与删除空行word vba-欢乐小爪
Access软件网QQ交流学习群(群号码198465573),欢迎您的加入!
首页 >技术文章> Access数据库-模块/函数/VBA


增加空行与删除空行word vba

发表时间:2012/5/21 10:46:30 评论(0) 浏览(13698)  评论 | 加入收藏 | 复制
   
摘 要:WORD  增加空行,删除空行
正 文:

Sub 每行增加一行空行()
Dim l As String
Dim LineCount As Integer
Dim i As Integer
Dim RangeStart As Long
Dim RangeEnd As Long
Dim MyRange As Range
On Error Resume Next
Application.ScreenUpdating = False
CommandBars("Word Count").Visible = True
CommandBars("Word Count").Controls(2).Execute
l = CommandBars("Word Count").Controls(1).List(6)
CommandBars("Word Count").Visible = False
Application.ScreenUpdating = True

LineCount = Int(Mid(l, 1, Len(l) - 1))
With ActiveDocument
For i = LineCount To 1 Step -1
If .Content.End <= 1 Then Exit Sub
RangeStart = .GoTo(wdGoToLine, , i).Start
RangeEnd = VBA.IIf(i = LineCount, .Content.End, .GoTo(wdGoToLine, , i + 1).Start)
Set MyRange = .Range(RangeStart, RangeEnd)
'kk = Right(Replace(MyRange, " ", ""), 5)
MyRange.Select
Selection.MoveLeft
   Selection.TypeParagraph

Next
End With
End Sub
 
Sub 空行删除()
Dim l As String
Dim LineCount As Integer
Dim i As Integer
Dim RangeStart As Long
Dim RangeEnd As Long
Dim MyRange As Range
On Error Resume Next
Application.ScreenUpdating = False
Selection.WholeStory
CommandBars("Word Count").Visible = True
CommandBars("Word Count").Controls(2).Execute
l = CommandBars("Word Count").Controls(1).List(6)
CommandBars("Word Count").Visible = False
Application.ScreenUpdating = True

LineCount = Int(Mid(l, 1, Len(l) - 1))
With ActiveDocument
For i = LineCount To 1 Step -1
If .Content.End <= 1 Then Exit Sub
RangeStart = .GoTo(wdGoToLine, , i).Start
RangeEnd = VBA.IIf(i = LineCount, .Content.End, .GoTo(wdGoToLine, , i + 1).Start)
Set MyRange = .Range(RangeStart, RangeEnd)
'Debug.Print MyRange
 If MyRange = Chr(13) Then
 MyRange.Select
 Selection.MoveLeft
 Selection.TypeBackspace 

 End If
Next
End With
End Sub


Access软件网交流QQ群(群号:198465573)
 
 相关文章
今晚8点公益讲座《AccessVBA系列讲座之RunSQL方法》  【周芳  2013/4/18】
用access vba进行注册表设置,任务栏中的窗口,隐藏帮助框,...  【th  2013/4/20】
常见问答
技术分类
相关资源
文章搜索
关于作者

欢乐小爪

文章分类

文章存档

友情链接