ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hyperlink from Excel to a Word bookmark (https://www.excelbanter.com/excel-discussion-misc-queries/88844-hyperlink-excel-word-bookmark.html)

Bertie

hyperlink from Excel to a Word bookmark
 
How can I insert a hyperlink in Excel which links to a particular bookmark in
a Word document?
--
Bertie C

Bertie

hyperlink from Excel to a Word bookmark
 
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.
--
Bertie C


"Bertie" wrote:

How can I insert a hyperlink in Excel which links to a particular bookmark in
a Word document?
--
Bertie C


Dave Peterson

hyperlink from Excel to a Word bookmark
 
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")



Bertie wrote:

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.
--
Bertie C

"Bertie" wrote:

How can I insert a hyperlink in Excel which links to a particular bookmark in
a Word document?
--
Bertie C


--

Dave Peterson


All times are GMT +1. The time now is 06:49 AM.

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