Microsoft Word bookmark content into an Excel cell using VBA

[Guest]

Hi everyone,

Does anybody know how I could enter a Microsoft Word bookmark content into
an Excel cell using VBA. So far, I've figured out how to open the Word
document from Excel, but that's where it stops.

My knowledge of the Word object model is limited.

Thanks for your help!

....Gaetan

 

[JE McGimpsey]

One way:

ActiveCell.Value = oDocument.Bookmarks("MyBookmark").Range.Text