How can I insert a hyperlink in Excel which links to a particular bookmark in a Word document?
B Bertie May 16, 2006 #1 How can I insert a hyperlink in Excel which links to a particular bookmark in a Word document?
B Bertie May 16, 2006 #2 I seem to have answered my own question. I created the bookmark in the Word document, then highlighted it and Copy, then selected the cell in Excel, Paste Special, Hyperlink - and it all seems fine.
I seem to have answered my own question. I created the bookmark in the Word document, then highlighted it and Copy, then selected the cell in Excel, Paste Special, Hyperlink - and it all seems fine.
D Dave Peterson May 16, 2006 #3 Another option: If you insert a bookmark in your MSWord file: Both of these worked ok for me: (Insert|hyperlink style) C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01 Or =hyperlink() style: =hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")
Another option: If you insert a bookmark in your MSWord file: Both of these worked ok for me: (Insert|hyperlink style) C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01 Or =hyperlink() style: =hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")
