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.

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}.

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.