Import Excel worksheet into Word with VBA

[trevorc]

Hi All,
I have been given the task of combining an Excel whorksheet into Word as a complete worksheet. Currently it is being done by creating an image of the worksheet as needed and the placing this in word, showing that it is page 1 of the total number of pages, then renumbering the rest of the doc to start at 2.



Can this bee done with VBA to directly paste the sheet into Word. Note that it also has several drwing objects around some cells that don't copy and paste with the sheet using a normal copy/paste operation.

Note, I'll cross post this in the Excel VBA forum as well.

[macropod]

Originally Posted by trevorc

Note, I'll cross post this in the Excel VBA forum as well.

Kindly don't do that. One thread per topic, please.

[macropod]

1. Why do you need VBA for this?
2. Is a link between the document and workbook required, so that workbook updates are reflected in the document?
3. You should be aware that linked workbook objects cannot span Word pages; they must reside entirely on a single page.