Using templates and bookmarks
To copy an entire Excel spreadsheet and paste it into Word doesn't make sense. You could rather have done everything in Word from the beginning, saving you the whole effort of copying from Excel and pasting in Word.
The point is, if you have an existing Word document or even a Word template, and you regularly need to export selected information from a spreadsheet in Excel to this template, this is the way to do it. The word automation acquires new meaning if you can link Excel with Word in this manner.
In this recipe, we will be pasting Excel data into a Word document at a specific bookmark.
Getting ready
Make sure that Word_Interaction.xlsm is still open, and that the VBA Editor is active.
How to do it…
We need to do the following:
- Open the Word document that was saved to the desktop. Delete the inserted table, (select only the entire table – no lines before or after, click the Layout contextual tab, and then...
