export excel data to a word template using a macro

I am trying to poulate a word document with excel data using a macro

I never found an efficient way to do this, I did find a hokey way to do
this though:

In your word template run a macro that open your excel file.
In the excel create a macro that runs when opened. In the excel macro,
write what ever groups of text you need to multiple temporary text
files, and have your macro close with out saving changes. Then have
your word macro import the temp files one at a time where ever you want
them, then delete them from the hard drive.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!