A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking from Excel Worksheet to a Bookmark in Word



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2004, 02:08 AM
Kim Finleyson
external usenet poster
 
Posts: n/a
Default Linking from Excel Worksheet to a Bookmark in Word

Can anyone tell me how to create a hyperlink in an Excel
worksheet that would open a specific Word document at a
specified bookmark within the Word document?

Example: My Excel worksheet includes a cell
referencing "Spec-01". A lengthy Word document contains a
paragraph explaining "Spec-01." I want to add a hyperlink
in the spreadsheet that would open the Word document and
go immediately to the "Spec-01" bookmark without the user
having to scroll down.

Would I need to write some kind of macro to do this, or
is there someway within Excel to specify a certain
location in a Word document? I'm using Word/Excel 2000.

Thanks!
Kim F.
  #2  
Old April 16th, 2004, 02:09 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default Linking from Excel Worksheet to a Bookmark in Word

Hi Kim,
There probably aren't that many Word people in this Excel newsgroup,
so perhaps you can answer some questions, and provide more detail.
- Can you link to a bookmark from within another Word document.
- Can you link to a bookmark within a Word document from HTML

Take a look at
http://www.mvps.org/dmcritchie/excel/sheets.htm

Try something like:
http://www.xyz.com/mydocument.doc#bookmark3

I suspect that you can't because I've seen the question go
unanswered.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kim Finleyson" wrote in message ...
Can anyone tell me how to create a hyperlink in an Excel
worksheet that would open a specific Word document at a
specified bookmark within the Word document?

Example: My Excel worksheet includes a cell
referencing "Spec-01". A lengthy Word document contains a
paragraph explaining "Spec-01." I want to add a hyperlink
in the spreadsheet that would open the Word document and
go immediately to the "Spec-01" bookmark without the user
having to scroll down.

Would I need to write some kind of macro to do this, or
is there someway within Excel to specify a certain
location in a Word document? I'm using Word/Excel 2000.

Thanks!
Kim F.



  #3  
Old April 16th, 2004, 08:11 PM
Kim Finleyson
external usenet poster
 
Posts: n/a
Default Linking from Excel Worksheet to a Bookmark in Word

David,

Yes, I can cross-reference a bookmark inside a Word
document to a bookmark in the same Word document, which is
actually an internal hyperlink (you can click on it). I
don't know how to do it from HTML to Word. It's easy to
link from one HTML document to a targeted position in
another HTML document, but I'm trying to jump between
Excel and a targeted position (bookmark) in Word.

Microsoft Knowledge Base has an article that references a
similar subject between Access and Excel/Word: "How to
Programmatically Embed or Link an Object in a Form"
(http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/q1
14/2/14.asp&NoWebContent=1).... However I was really,
really hoping there'd be some code I could embed directly
in my worksheet that would open the Word doc and position
to some pre-selected text.

Well, I will keep looking, and in the meantime if you
think of something, or even think of a creative work-
around, I'd be much appreciative!!!

Thanks,
Kim

(work email: Kim@no spamPCSSInc.com






-----Original Message-----
Hi Kim,
There probably aren't that many Word people in this Excel

newsgroup,
so perhaps you can answer some questions, and provide

more detail.
- Can you link to a bookmark from within another Word

document.
- Can you link to a bookmark within a Word document

from HTML

Take a look at
http://www.mvps.org/dmcritchie/excel/sheets.htm

Try something like:
http://www.xyz.com/mydocument.doc#bookmark3

I suspect that you can't because I've seen the question go
unanswered.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed

Nov. 2001]
My Excel Pages:

http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:

http://www.mvps.org/dmcritchie/excel/search.htm

"Kim Finleyson" wrote in message

...
Can anyone tell me how to create a hyperlink in an Excel
worksheet that would open a specific Word document at a
specified bookmark within the Word document?

Example: My Excel worksheet includes a cell
referencing "Spec-01". A lengthy Word document contains

a
paragraph explaining "Spec-01." I want to add a

hyperlink
in the spreadsheet that would open the Word document and
go immediately to the "Spec-01" bookmark without the

user
having to scroll down.

Would I need to write some kind of macro to do this, or
is there someway within Excel to specify a certain
location in a Word document? I'm using Word/Excel 2000.

Thanks!
Kim F.



.

  #4  
Old April 16th, 2004, 08:29 PM
Dick Kusleika
external usenet poster
 
Posts: n/a
Default Linking from Excel Worksheet to a Bookmark in Word

Kim

Go to Insert-Hyperlink and in the File textbox, type:

C:\MyPath\MyWord.doc#MyBkMark

The # followed by the bookmark name sets the SubAddress of the hyperlink.
This worked for me in Excel2000.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Kim Finleyson" wrote in message
...
David,

Yes, I can cross-reference a bookmark inside a Word
document to a bookmark in the same Word document, which is
actually an internal hyperlink (you can click on it). I
don't know how to do it from HTML to Word. It's easy to
link from one HTML document to a targeted position in
another HTML document, but I'm trying to jump between
Excel and a targeted position (bookmark) in Word.

Microsoft Knowledge Base has an article that references a
similar subject between Access and Excel/Word: "How to
Programmatically Embed or Link an Object in a Form"
(http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/q1
14/2/14.asp&NoWebContent=1).... However I was really,
really hoping there'd be some code I could embed directly
in my worksheet that would open the Word doc and position
to some pre-selected text.

Well, I will keep looking, and in the meantime if you
think of something, or even think of a creative work-
around, I'd be much appreciative!!!

Thanks,
Kim

(work email: Kim@no spamPCSSInc.com






-----Original Message-----
Hi Kim,
There probably aren't that many Word people in this Excel

newsgroup,
so perhaps you can answer some questions, and provide

more detail.
- Can you link to a bookmark from within another Word

document.
- Can you link to a bookmark within a Word document

from HTML

Take a look at
http://www.mvps.org/dmcritchie/excel/sheets.htm

Try something like:
http://www.xyz.com/mydocument.doc#bookmark3

I suspect that you can't because I've seen the question go
unanswered.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed

Nov. 2001]
My Excel Pages:

http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:

http://www.mvps.org/dmcritchie/excel/search.htm

"Kim Finleyson" wrote in message

...
Can anyone tell me how to create a hyperlink in an Excel
worksheet that would open a specific Word document at a
specified bookmark within the Word document?

Example: My Excel worksheet includes a cell
referencing "Spec-01". A lengthy Word document contains

a
paragraph explaining "Spec-01." I want to add a

hyperlink
in the spreadsheet that would open the Word document and
go immediately to the "Spec-01" bookmark without the

user
having to scroll down.

Would I need to write some kind of macro to do this, or
is there someway within Excel to specify a certain
location in a Word document? I'm using Word/Excel 2000.

Thanks!
Kim F.



.



  #5  
Old April 16th, 2004, 08:55 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default Linking from Excel Worksheet to a Bookmark in Word

In article ,
"David McRitchie" wrote:

Hi Kim,
There probably aren't that many Word people in this Excel newsgroup,
so perhaps you can answer some questions, and provide more detail.
- Can you link to a bookmark from within another Word document.
- Can you link to a bookmark within a Word document from HTML

Take a look at
http://www.mvps.org/dmcritchie/excel/sheets.htm

Try something like:
http://www.xyz.com/mydocument.doc#bookmark3

I suspect that you can't because I've seen the question go
unanswered.


FWIW, I've successfully used exactly that syntax in MacXL v.X. I've not
tried it in XL03, but I'll put it on my list.

XL doesn't read the bookmarks of the Word document, so the anchor
(#bookmark) needs to be entered by hand.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.