Use ADO to open a Word file from Excel?
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
|