ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel Hyperlink question (https://www.excelbanter.com/excel-discussion-misc-queries/35295-excel-hyperlink-question.html)

Pam Coleman

excel Hyperlink question
 
Is there a way I can have a spreadsheet that in one column on a particular
cell there will be a hyperlink to a word document?

s boak

Under the Insert Hyperlink menu, I think if you select the "Existing File or
Web Page" button and point to what you want, that should do it.
HTH
Steve

"Pam Coleman" wrote in message
...
Is there a way I can have a spreadsheet that in one column on a particular
cell there will be a hyperlink to a word document?




Pam Coleman

Is there a way the hyperlink will be directed to a certain part of the word
document?

"s boak" wrote:

Under the Insert Hyperlink menu, I think if you select the "Existing File or
Web Page" button and point to what you want, that should do it.
HTH
Steve

"Pam Coleman" wrote in message
...
Is there a way I can have a spreadsheet that in one column on a particular
cell there will be a hyperlink to a word document?





Dave Peterson

If you insert a bookmark in your MSWord file:

Both of these worked ok for me:

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



Pam Coleman wrote:

Is there a way the hyperlink will be directed to a certain part of the word
document?

"s boak" wrote:

Under the Insert Hyperlink menu, I think if you select the "Existing File or
Web Page" button and point to what you want, that should do it.
HTH
Steve

"Pam Coleman" wrote in message
...
Is there a way I can have a spreadsheet that in one column on a particular
cell there will be a hyperlink to a word document?





--

Dave Peterson


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com