Adding MS Word cross-reference in Excel cell

E

Emilio

In an Excel spreadsheet, I would like to add cross-
references to individual section headings of an MS Word
document. In the Excel cell, I don't want to reference
the entire Word document, but actual section headings
within the Word document.

Any help would be much appreciated. Thanks in advance.
Emilio
 
D

Dave Peterson

I'm not sure this is best, but if you inserted a bookmark in your word document,
you could include that in your hyperlink:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC##bkmk01

=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top