Excel Object Model and Embedded Word Document

[jc511085]

Hello Everyone

FIrst thank you to all the contributors (may I'll be one one day) to the knowledge base and forum, this greatly helps people who struggle in order to answer requests.

Would you know where I could find an exhaustive, freely available if possible, Excel object model?

I had several looks at microsoft but I may not be in the same logic as they are because sometimes it seems to lack some information.

My last research was related to embedded Word document in Excel an especially how to deal with headers and footers.

I wanted to be able to edit a header composed of a table of one row and three columns and change the contents of one of the "column/cell" I manage to do this but it relies on knowing the number of words:

WrdApp.Selection.Sections(1).Headers(1).Range.Tables.Item(1).Range.Words(
9).Text="xxx"

Hence my question about the object model.

Thank you in advance for any response.

Best regards

Jean-Michel.

[Tinbendr]

You should be able to access it directly.

(Not checked)


'Table 1, Cell 1.
WrdApp.Tables(1).Cell(1, 1).Range.Text = "Testing"

[jc511085]

Thank you David.

I'll try it and let you know.