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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|