Word doc embedded object

[IRish3538]

Hi everyone, this is kind a of a weird, specific question and I've had no luck researching it on my own. I have a wb that has an embedded word doc inside it and I have a macro that uses the word doc to generate a report. It works fine, but for some reason, with an embedded document, once edditted, the doc automatically saves itself upon closing. So if the user generates a report, then closes the doc and tries to generate another report, it copies next to the now-prefilled word doc. I hope I'm not too confusing... anyway does anyone know what I'm talking about or have any idea how to fix/work around it? Thanks so much for the help!

[lucas]

I would avoid it by copying the data from excel into a Word template that is already set up:
http://vbaexpress.com/kb/getarticle.php?kb_id=436

[IRish3538]

Yeah... that's how I have it set up as is, but my wb is going to be used by several people so i figured the less files the less margin for error. Thanks for the input! I kind of figured that it wasn't going to be a viable option.

[lucas]

You can also set up a hidden template sheet in Excel and copy it and use it for your report each time....I find there is little you can do in Word as far as generating reports that can't be done completely in Excel....