Linking from Excel to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if there is a way to link from an Excel file, to different
locations within a single word document. I have successfully linked from an
Excel file to another word document, which links to another word document.
However, when I try to link from an Excel file to separate headers from
within the same word document, I am unsuccessful…and, each time, simply link
to the top of the word document.

Is there a way to solve this? Any help is much appreciated.
 
You're writing about hyperlinks???

If yes, insert a bookmark in your word file and use a hyperlink like:

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

Or

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


If I understood correctly????
 
Cheers Dave....yes, I was talking about hyperlinks, my apologies. However,
when I try to do what you said I have little joy....I simply open the Word
document and the cursor appears at the top, as opposed to jumping to the
specific bookmarked location.
 
I tested in office 2002 (but I would expect the behavior in previous versions,
too.

You may want to try a small test to make sure you're spelling your bookmarks the
same way.

I opened MSWord and in a new document, I typed:

=rand(10,12)

(a neat function that will create dummy text (10 paragraphs of 12 sentences
each)--only if you have "replace text as you type" enabled in MSWord (under
tools|autocorrect options|autocorrect tab).

I scrolled down a bit and inserted a bookmark (insert|bookmark).

Then I saved my document as mydoc.doc
and closed Word.

And put both of those versions of the hyperlink into a new worksheet in a new
workbook:

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

And each worked ok.

I'm hoping that the little test works ok for you and you find it was a simple
typo, so it's easy to fix.
 
Back
Top