accessing an embedded Excel sheet

[stupotthesecond]

Hi all,

Using VB, how do I access an Excel sheet that is embedded in a word document, so that I can can write to the cells in that sheet.

Thanks,

Stuart.

 

[shakespeare5677]

Just as a quick suggestion, try recording a macro, select the excel sheet and edit it, stop recording and look at the code. That may tell you what object to activate and how to edit it.
-Max

 

[shakespeare5677]

If you're happy with what you get, just adopt copy it and adopt it for vb.
-Max