ExcelBanter - how to hyperlink to a paragraph in a word file?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to hyperlink to a paragraph in a word file? (https://www.excelbanter.com/excel-discussion-misc-queries/192507-how-hyperlink-paragraph-word-file.html)

ViestaWu

how to hyperlink to a paragraph in a word file?

I know how to use hyperlink basicly. but this time, I want to link a
paragraph in another word file from my Excel.
Does anyone have same experience? Please share me with your success!
Thanks at advance!

Dave Peterson

how to hyperlink to a paragraph in a word file?

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

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

ViestaWu wrote:

I know how to use hyperlink basicly. but this time, I want to link a
paragraph in another word file from my Excel.
Does anyone have same experience? Please share me with your success!
Thanks at advance!

--

Dave Peterson

ViestaWu

how to hyperlink to a paragraph in a word file?

It seems that this function doesn't work. Anything else?

"Dave Peterson" wrote:

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

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

ViestaWu wrote:

I know how to use hyperlink basicly. but this time, I want to link a
paragraph in another word file from my Excel.
Does anyone have same experience? Please share me with your success!
Thanks at advance!

--

Dave Peterson

Dave Peterson

how to hyperlink to a paragraph in a word file?

They both worked ok for me.

ViestaWu wrote:

It seems that this function doesn't work. Anything else?

"Dave Peterson" wrote:

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

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

ViestaWu wrote:

I know how to use hyperlink basicly. but this time, I want to link a
paragraph in another word file from my Excel.
Does anyone have same experience? Please share me with your success!
Thanks at advance!

--

Dave Peterson

--

Dave Peterson

All times are GMT +1. The time now is 10:15 PM.