Embedded Excel object inside Word document

[hatchetman]

I am writing a Visual Basic application that needs to modify an Excel object within a MS Word document. I know how to reference the Word document, but I don't know how to reference the Excel object within the Word document reference. I copied a section of an existing Excel document and did a "Paste Special" into the Word document (as "Microsoft Excel Worksheet Object&quot. Then I want to pass an argument to a MS Query that is associated with the Excel part. Am I asking too much? While I'm at it, is it possible to pass an argument to a MS Query within an Excel document from Visual Basic?

so far...

Dim WordApp as Word.Application
Dim WordDoc as Word.Document
Dim ExcelApp as Excel.Application
Dim ExcelObject as ?

Set WordApp = CreateObject("Word.Application&quot
Set WordDoc = WordApp.Document.Open("test.doc&quot

Set ExcelApp = CreateObject("Excel.Application&quot
Set ExcelObject = WordDoc.???????

 

[MarkSweetland]

Here is the URL for a very detailed explaination on this subject:

http://www.scottm.dircon.co.uk/vbatips/word/oleembed/embedded.htm

Mark