How to control Excel worksheet embedded in Word document

[ctbaker]

I have a word document with an excel worksheet embedded in it via the INSERT -> OBJECT -> EXCEL WORKSHEET commands. How do I select and write data to this excel object that is inside a word document?

I have used XLApp.<blah> and WordApp.<blah> commands but how do I get at the Excel app inside a Word app?

And while I am asking, I use XLSheet.Cells(r,c).Value = &quot;blah&quot; to write data to excel. How do you write text to Word documents?

Thanks,
Chad

 

[Mike Gagnon]

ctbaker

I researched this a while ago, and based on my experience the OLE object cannot be edited that way, but if they are linked to the original document you most likely could automate Excel and show the rulting changes in you Word document.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.