Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Hyperlink a word document to an excel spreadsheet

I know how to link a word document, but I want to know if there is a way to
have that link go to a certain section of the document?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Hyperlink a word document to an excel spreadsheet

So you want to add a hyperlink in an excel document that links to a certain
location in an MSWord file?

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")



Noel wrote:

I know how to link a word document, but I want to know if there is a way to
have that link go to a certain section of the document?

Thanks


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Hyperlink a word document to an excel spreadsheet

When I do this, I click on the hyperlink I have in Excel, and then it takes
me to the word document but gives me a pop up box saying "Convert file from"
and then it gives options. What file is it wanting me to convert? It has a
drop down list to choose from.
Thanks

"Dave Peterson" wrote:

So you want to add a hyperlink in an excel document that links to a certain
location in an MSWord file?

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")



Noel wrote:

I know how to link a word document, but I want to know if there is a way to
have that link go to a certain section of the document?

Thanks


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert excel document to word document (not a picture) frendabrenda1 Excel Discussion (Misc queries) 2 October 6th 06 03:55 PM
how do i add a word document into an excel spreadsheet? G-Man Excel Discussion (Misc queries) 1 May 28th 06 05:40 PM
Copy a word doc to excel and hyperlink data between the 2. link an excell and word document Charts and Charting in Excel 0 January 16th 06 11:16 PM
How do I import an excel spreadsheet to a word document Amuse Excel Discussion (Misc queries) 0 July 10th 05 10:30 PM
Getting specific data from a word document into an excel sheet smintey Excel Worksheet Functions 3 December 7th 04 05:17 PM


All times are GMT +1. The time now is 07:58 AM.

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

About Us

"It's about Microsoft Excel"