Forum Discussion

William Lawrence's avatar
William Lawrence
Copper Contributor
Mar 01, 2017

Importing Bookmarked text from Word Document

I have bookmarked certain text in a Word document, and I'm trying to link that text into an excel spreadsheet using Excel 2016. 

 

Previously w Office 2010 I was able to do this using this formula:

 

=Word.Document.12|'C:\Users\wlawrence\Desktop\Data\Source.docx'!'!BookmarkName1'

 

This would find the Word file in the "Data" folder, and show the text that was bookmarked with the name BookmarkName1.

 

Now all I get is a #REF error, and I can't figure out why it is no longer working. 

 

Does anyone know whether this feature is no longer supported in Excel 2016?  Or otherwise how to do this?  thanks

 

  • Hi William,

     

    I tested right now, it works like this

    =Word.Document|'G:\Data\TB.docx'!'!Test1'

    Excel 2016 and Word2016

     

Resources