> a) open a word document from excel
> b) copy some text across
> c) let excel carry on when the document has been closed

> For part b) I was going to put the text into the clipboard (this is
> easy) and use SendKeys, but I can't see this being reliable.  I could
> create is as a mail merge document, but this seems excessive - is there
> an easier way

> For a) and c) I am using something called ShellAndWait I picked up off
> the net.  This is just basically the Shell command with a few APIs
> around it which get various handles, and loop until the process dies,
> but I'd prefer to use automation if this helps with my answer to b).

> If I am to paste the text in rather than mailmerge, I take it I just
> need chr(13)'s where I want the carriage returns to be (I am pulling
> addresses from cells on a spreadsheet and want to print this as an
> address label)
> --
> Mike

>Start with the article "Control Word from Excel" at
>http://www.mvps.org/word/FAQs/InterDev/ControlWordFromXL.htm

> >Start with the article "Control Word from Excel" at
> >http://www.mvps.org/word/FAQs/InterDev/ControlWordFromXL.htm

> Thanks - I am starting to make some progress.  It does say however to
> add the code below....  If the sub is going to end, won't the variables
> be discarded anyway.  I see people put this in, and don't really
> understand why

> 'Make sure you release object references.
> Set oWord = Nothing
> Set oDoc = Nothing

> --
> Mike

>Perhaps a programmer can chime in here (I'm a techncial writer), but my
>understanding is that statements like these (Set oWord = Nothing) release
>the memory location that the program used to create your object. So my
>tidbits are
>    1) this is a "clean up" practice
>    2) this is standard practice
>    3) this is good practice.