ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Distributing hyperlinked documents (https://www.excelbanter.com/excel-discussion-misc-queries/215628-distributing-hyperlinked-documents.html)

FredN

Distributing hyperlinked documents
 
I need to distribute an Excel document and a Word document that are
hyperlinked. The Excel doc links to bookmarks in the Word doc. Can I address
the hyperlinks so that if a recipient places both documents in any folder
they function properly? Will appreciate any help you can give.
--
FredN

Bob I

Distributing hyperlinked documents
 
the hyperlink would have to be(and remain as) ..\filename.ext

FredN wrote:

I need to distribute an Excel document and a Word document that are
hyperlinked. The Excel doc links to bookmarks in the Word doc. Can I address
the hyperlinks so that if a recipient places both documents in any folder
they function properly? Will appreciate any help you can give.



FredN

Distributing hyperlinked documents
 
Thanks for the reply Bob I.
I tried it but had no luck. I'm using XP. Wouldn't open the file. In case
it's bad syntax here's the line: =HYPERLINK("..\081230 TEMP testing
outline.doc","test2")
--
FredN


"Bob I" wrote:

the hyperlink would have to be(and remain as) ..\filename.ext

FredN wrote:

I need to distribute an Excel document and a Word document that are
hyperlinked. The Excel doc links to bookmarks in the Word doc. Can I address
the hyperlinks so that if a recipient places both documents in any folder
they function properly? Will appreciate any help you can give.




FredN

Distributing hyperlinked documents
 
Bob I, Fooled around and found that .\ works! Had forgotten what I learned in
dos. Thanks again.
--
FredN


"Bob I" wrote:

the hyperlink would have to be(and remain as) ..\filename.ext

FredN wrote:

I need to distribute an Excel document and a Word document that are
hyperlinked. The Excel doc links to bookmarks in the Word doc. Can I address
the hyperlinks so that if a recipient places both documents in any folder
they function properly? Will appreciate any help you can give.




Bob I

Distributing hyperlinked documents
 
My mistake. I just checked a CD that I did a few years back and the
hyperlink contains just the file name.

FredN wrote:

Thanks for the reply Bob I.
I tried it but had no luck. I'm using XP. Wouldn't open the file. In case
it's bad syntax here's the line: =HYPERLINK("..\081230 TEMP testing
outline.doc","test2")



Bob I

Distributing hyperlinked documents
 
You're welcome. See my other reply also.

FredN wrote:

Bob I, Fooled around and found that .\ works! Had forgotten what I learned in
dos. Thanks again.




All times are GMT +1. The time now is 10:16 AM.

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