Created
July 25, 2016 14:30
-
-
Save sivartravis/0b58aeec84523a7c8508750be9d9b299 to your computer and use it in GitHub Desktop.
The following macro copies text one page at a time and then saves that text in a new document. The macro uses the pre-defined bookmark "\page" and the document's built-in property of "number of pages".
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The following macros show how to break up a multi-page document into separate files. The two macros use the Page or Section property of a Microsoft Word document to select and move through the document content. This code can be used in an automation scenario with Word not visible. | |
MORE INFORMATION | |
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. | |
Separate File by Page | |
Sub BreakOnPage() | |
' Used to set criteria for moving through the document by page. | |
Application.Browser.Target = wdBrowsePage | |
For i = 1 To ActiveDocument.BuiltInDocumentProperties("Number of Pages") | |
'Select and copy the text to the clipboard | |
ActiveDocument.Bookmarks("\page").Range.Copy | |
' Open new document to paste the content of the clipboard into. | |
Documents.Add | |
Selection.Paste | |
' Removes the break that is copied at the end of the page, if any. | |
Selection.TypeBackspace | |
ChangeFileOpenDirectory "C:\" | |
DocNum = DocNum + 1 | |
ActiveDocument.SaveAs FileName:="test_" & DocNum & ".doc" | |
ActiveDocument.Close | |
' Move the selection to the next page in the document | |
Application.Browser.Next | |
Next i | |
ActiveDocument.Close savechanges:=wdDoNotSaveChanges | |
End Sub | |
Separate File by Section | |
The following macro copies text one section at a time and then saves that text in a new document. The macro uses the pre-defined bookmark "\section" to create the new document. This macro is useful for breaking up a mail merge "Merge to New Document" file. | |
Sub BreakOnSection() | |
' Used to set criteria for moving through the document by section. | |
Application.Browser.Target = wdBrowseSection | |
'A mailmerge document ends with a section break next page. | |
'Subtracting one from the section count stop error message. | |
For i = 1 To ((ActiveDocument.Sections.Count) - 1) | |
'Select and copy the section text to the clipboard | |
ActiveDocument.Bookmarks("\Section").Range.Copy | |
'Create a new document to paste text from clipboard. | |
Documents.Add | |
Selection.Paste | |
' Removes the break that is copied at the end of the section, if any. | |
Selection.MoveUp Unit:=wdLine, Count:=1, Extend:=wdExtend | |
Selection.Delete Unit:=wdCharacter, Count:=1 | |
ChangeFileOpenDirectory "C:\" | |
DocNum = DocNum + 1 | |
ActiveDocument.SaveAs FileName:="test_" & DocNum & ".doc" | |
ActiveDocument.Close | |
' Move the selection to the next section in the document | |
Application.Browser.Next | |
Next i | |
ActiveDocument.Close savechanges:=wdDoNotSaveChanges | |
End Sub | |
NOTE: When this code is used to select and copy the text content of the document, the header and footer are not retained. Styles, fonts, and layout may change if the main file and the new document are from different templates, but direct formatting is maintained. | |
For more information about bookmarks, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type bookmark in the Office Assistant or the Answer Wizard, and then click Search to view the topic. | |
For more information about browser, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type target property in the Office Assistant or the Answer Wizard, and then click Search to view the topic. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment