Import Excel worksheet into Word with VBA
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.
|