Next, draw the command button on the right side of the sheet. In the drop-down list, select the Button control under ActiveX Controls. Select Developer from the menu and select Insert from the Controls group in the ribbon. To do this, you’ll need to write a VBA function that’ll run when you click a “Copy To Word” button. Let’s say you’d like to copy and paste the entire range of cells in this worksheet into a Word document.

This sample is a list of purchase orders for a variety of products. In both examples, we’ll start with a sample Excel spreadsheet. Copy And Paste An Excel Range Into Word With VBA In this article, you’ll learn how to write VBA code to automate these actions between Excel and Word. You could try to record a macro to do this, but macros will only let you automate tasks inside of Word. The second is performing calculations in Excel, creating a new table in Word, and writing the results to the table.

The first is automating a straight copy and paste of an existing range from Excel into a new table in a Word document.

Vba copy word table to excel