word template vb problem

A

aps1315

VB Newbie here ... thanks in advance for any help.

Have some code (not mine) that transfers copy/pastes a metafile from Excel
into Word. The file is pasted onto a .dot which is two pages. First page
being intro information, the second page of the template containing
appropriate formatting for what should be the second and third pages. What's
happening is when the second piece of the metafile is pasted, it is pasted
onto the entire template again. So the currently generated .doc has this
strucutre:

P1 - Intro from template
P2 - Part I of metafile
P3 - Intro from template
P4 - Part II of metafile

I would like to generate a .doc with the following strucutre:

P1 - Info from template
P2 - Part I of metafile
P3 - Part II of metafile

Seems like writing some code to always select and delete page 3 would work,
but if there are more elegant and efficient solutions out there, I would
certainly appreciate the assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top