I've inserted a Word document as an OBJECT in my spreadsheet and am trying to do the equivalent of a SELECT ALL, COPY so I can paste the data to the spreadsheet directly.
The problem is, as soon as the Word Object is Selected (i.e Double Clicked), WORD becomes the Active Application (even within Excel)
Presently, I have the user EDIT/SELECT ALL and then EDIT/COPY and then click a command button in Excel to do the rest. (BTW, a WORD macro cannot be attached to the WORD document being loaded.)
Any ideas on how to do this via MACRO in Excel? (When the Word document is selected, the top menu reverts to WORD's menu - and SELECTION.WHOLESTORY (Select All via Word's menu) is not supported (?) in Excel.
Any suggestions on a work around would be much appreciated!
Thanks!!
The problem is, as soon as the Word Object is Selected (i.e Double Clicked), WORD becomes the Active Application (even within Excel)
Presently, I have the user EDIT/SELECT ALL and then EDIT/COPY and then click a command button in Excel to do the rest. (BTW, a WORD macro cannot be attached to the WORD document being loaded.)
Any ideas on how to do this via MACRO in Excel? (When the Word document is selected, the top menu reverts to WORD's menu - and SELECTION.WHOLESTORY (Select All via Word's menu) is not supported (?) in Excel.
Any suggestions on a work around would be much appreciated!
Thanks!!