View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claud Balls Claud Balls is offline
external usenet poster
 
Posts: 72
Default export excel data to a word template 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!