How to create link b/n Excel worksheet (cell) and Word document?
I need to insert a link into specific cell of an Excel worksheet to a
specific part of a word document. I have tried using Hypserlink - doesn't work. I have tried using Copy, Paster Special as a link - doesn't work either. |
How to create link b/n Excel worksheet (cell) and Word document?
Why doesn't it work? What DOES occur? Did you Insert--Bookmark into the Word
document, and then insert a hyperlink to the bookmark? (i.e., "C:\\mydocument.doc#mybookmark") -- ~Anne Troy www.OfficeArticles.com "Irina" wrote: I need to insert a link into specific cell of an Excel worksheet to a specific part of a word document. I have tried using Hypserlink - doesn't work. I have tried using Copy, Paster Special as a link - doesn't work either. |
How to create link b/n Excel worksheet (cell) and Word document?
Saved from a previous post:
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") Irina wrote: I need to insert a link into specific cell of an Excel worksheet to a specific part of a word document. I have tried using Hypserlink - doesn't work. I have tried using Copy, Paster Special as a link - doesn't work either. -- Dave Peterson |
How to create link b/n Excel worksheet (cell) and Word documen
"Dave Peterson" wrote: Saved from a previous post: 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") Irina wrote: I need to insert a link into specific cell of an Excel worksheet to a specific part of a word document. I have tried using Hypserlink - doesn't work. I have tried using Copy, Paster Special as a link - doesn't work either. -- Dave Peterson ... Still searching through the posts for something relevant to me but I'm looking to have an Excel calendar, that when I click on a specific cell (i.e. date) it opens an existing Word doc and inserts that date so I can begin typing information for that date. Thanks for the help, Gary |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com