View Single Post
 
Old 12-05-2018, 01:04 AM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default 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.
Reply With Quote