Newbie here ... Working with some inherited code ...

Have code that tranfers data from Excel to Word. The .doc used as template (template.doc) to present the Excel data is two pages. The metafile transferred to .doc never spans more than two pages.

So the end result is that the generated .doc (result.doc) is four pages. With the third page being, logically, Page 1 of template.doc with the remainder of the transferred metafile on Page 4. What I'm shooting for is for result.doc to be presented thusly:

Page 1 - Page 1 of template.doc
Page 2 - Page 2 of template.doc with VB transferred metafile
Page 3 - Page 3 - presented using Page 2 of template.doc, with the remainder of the transferred metafile.

It seems that an easy fix would be to write a few lines to delete page 3 of result.doc to remove the extraneous page after result.doc has been generated. Anyone have any suggestions?

Thanks in advance for any help!