Refer to cell in embedded Excel object within word

[catflap]

Hi there



I have a word doc and have inserted the excel object within it. What I'd like to do is be able to refer to the value of cell A1 within the sheet with the aim of changing it from vba.

The goal is for me to get the value of a merge field from a datasource attached to the word doc, then change the cell value in the excel sheet to this merge value. I'd loop through the datasource one record at a time. This would hopefully be a bit of a kludge way of taking advantage of excel's ability to shrink or expand text to fit a box - something I've never found a way to do in a word mail-merge without a lot of trouble.

So what I need to know is how to refer to the cell in word vba.

Thanks for reading! - I know it's a bit convoluted but I thought I'd better explain it all.