Get Data from embedded Excel object

[gmaxey]

Can anyone advise me how to access data displayed in an Excel workbox object embedded in Word document. For example if I have an Excel object displayed my document that contains "Some text" in cell(A1), could access that data (e.g., to read it or set the value of another Word range)?

Thanks

[macropod]

See, for example, the macros I posted at:
https://social.msdn.microsoft.com/Forums/office/en-US/5955da06-725d-45f2-aa1b-5eb37c0646c6/how-to-convert-all-embeded-excel-sheets-in-word-into-words-tables?forum=worddev
Although they're designed to do something different, they do show how to go about accessing a range from the embedded workbook.

[gmaxey]

Paul,

I'll look at that. Thanks.