Automate Copy-Paste Between Documents in Word Using VBA

Sometimes, you may need to copy and paste multiple sections of content from one or more documents into a target document. Doing this manually by selecting the content, copying it, and then pasting it into the target document can be very time-consuming. In this guide, we will show you how to automate the process copy-paste between documents in word using VBA, allowing you to quickly and easily copy content from one document to another targeted document.

1. Open VBA Editor by Pressing ALT+F11

• In the VBA Editor Click on Insert Menu, then Click on Module to create a new module.

• Past the following VBA Code into the Module.

Sub automate_copyPast()
    ThisDocument.Activate
    Selection.Expand wdParagraph
    Selection.Copy
    Documents.Open "D:\targetDoc.docx"
    Selection.EndKey wdStory
    Selection.PasteAndFormat wdFormatOriginalFormatting
End Sub

• After pasting the code press CTRL+S to save the code, Press F5 to directly run the code and close VBA Editor.
• To test your macros, select some text in your document, then press ALT+F8. The macro dialog box will appear. Choose your macro from the list and click the “Run” button. The selected text will be copied and pasted into the target document

This way you can Automate Copy-Paste Between Documents in Word Using VBA

Note to make the process of copy-past of content to a targeted document more fast you can also assign keyboard shortcut to your VBA Macro click the following click if you to do so.

How to Assign keyboard shortcut to VBA Coded Macros

I hope this tutorial will helps you to automate the process of copy-past in word using VBA macro. If you have any query, suggestion or feedback feel free to contact using the information provided on our contact us page.

Thank you for your feedback and support.