How to Copy Columns in Excel Using VBA. Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks. Occasionally, you might find it necessary to copy and paste ...

Using Visual Basic for Applications you can insert Excel charts into a new PowerPoint presentation programmatically rather than using the cumbersome copy-and-paste method.

To do so, copy the Excel cells, table, or worksheet. In the Word or PowerPoint document, place the cursor where you would like the Excel contents pasted and choose Paste Special.

How to use the VBA procedure in Word As you can see in Figure D, the demonstration file comprises two pages and each page has two Word fields, {PAGE} and {NUMPAGES}.