Opening a word file from an Excel macro

Posted by Bob Boergman on November 06, 2001 6:39 AM

I have to open an word file from an excel macro. Once open paste data into the file then close the file.
Can this be done?
if so how?

Thank you

Posted by Leroy on November 06, 2001 10:17 AM

Bob,

Try this one.
3437.html

You can further use DDE to manipulate the word document.
HTH.