close

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

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 Cquot;Bertiequot; wrote:

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

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(quot;C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01quot;)
Bertie wrote:
gt;
gt; I seem to have answered my own question. I created the bookmark in the Word
gt; document, then highlighted it and Copy, then selected the cell in Excel,
gt; Paste Special, Hyperlink - and it all seems fine.
gt; --
gt; Bertie C
gt;
gt; quot;Bertiequot; wrote:
gt;
gt; gt; How can I insert a hyperlink in Excel which links to a particular bookmark in
gt; gt; a Word document?
gt; gt; --
gt; gt; Bertie C

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()