Forum Discussion
William Lawrence
Mar 01, 2017Copper Contributor
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