ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Microsoft Word bookmark content into an Excel cell using VBA (https://www.excelbanter.com/excel-discussion-misc-queries/134229-microsoft-word-bookmark-content-into-excel-cell-using-vba.html)

Gaetan

Microsoft Word bookmark content into an Excel cell using VBA
 
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

Microsoft Word bookmark content into an Excel cell using VBA
 
One way:

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


In article ,
Gaetan wrote:

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



All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com