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/Fo...?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.