![]() |
|
#1
|
|||
|
|||
![]()
need macro to run on all files in folder
Sub BreakLines() Application.ScreenUpdating = False With ActiveDocument.Content.Paragraphs .FirstLineIndent = 0 .LeftIndent = 0 End With Selection.HomeKey Unit:=wdStory Do Selection.EndKey Unit:=wdLine If Selection.End >= ActiveDocument.Content.End - 1 Then Exit Do End If If Asc(Selection) <> 13 Then Selection.InsertParagraphAfter End If Selection.MoveDown Unit:=wdLine Loop Application.ScreenUpdating = True End Sub |
#2
|
||||
|
||||
![]()
See http://www.gmayor.com/document_batch_processes.htm which will handle the folders'
Then change your macro to the following and run it as a custom process. Code:
Function BreakLines(oDoc As Document) As Boolean On Error GoTo err_Handler Application.ScreenUpdating = False With ActiveDocument.Content.Paragraphs .FirstLineIndent = 0 .LeftIndent = 0 End With Selection.HomeKey Unit:=wdStory Do Selection.EndKey Unit:=wdLine If Selection.End >= ActiveDocument.Content.End - 1 Then Exit Do End If If Asc(Selection) <> 13 Then Selection.InsertParagraphAfter End If Selection.MoveDown Unit:=wdLine Loop Application.ScreenUpdating = True BreakLines = True lbl_Exit: Exit Function err_Handler: BreakLines = False Resume lbl_Exit End Function
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
![]() |
Tags |
macro, macro vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Yisrael | Word VBA | 6 | 03-25-2017 11:24 PM |
Macro to change/convert/delete txt files in folder+subfolders | NoS | Word VBA | 4 | 03-03-2016 12:10 PM |
Macro to replace SSN in all files within a folder | caj1980 | Word VBA | 7 | 09-11-2014 04:17 PM |
![]() |
expert4knowledge | Word VBA | 5 | 07-10-2014 03:54 PM |
![]() |
patidallas22 | Word VBA | 2 | 03-09-2012 08:14 AM |