I need to create an Excel macro that opens any Word file, does a select all (Ctrl-A), copies all the selected text to the clipboard (Ctrl-C), and then closes Word. I think ADO functions can do this quickly and in a non-visible manner. Anyone know how to do this?

-Robert

I need to create an Excel macro that opens any Word file, does a select all
(Ctrl-A), copies all the selected text to the clipboard (Ctrl-C), and then
closes Word. I think ADO functions can do this quickly and in a non-visible
manner. Anyone know how to do this?

-Robert

You could easily automate an 'instance' of Word and have it open the document
for you, all behind the scene since your Word instance will not be visible
until you make it so if giving your user interactive access to it. I don't use
Word much so you'll have to google for help automating it, but the same VBA
that works in Word will also work with your object ref to your Word instance in
Excel.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion