HYPERLINK - alternative to

[orlando_l.]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create hyperlinks in an Excel sheet, to documents (pdfs primarily)

My documents are within a devonthink database, and the URL to access them start with " x-devonthink-item:// ".

I am able to reach into the document within my devonthink database, when entering or clicking in the URL link from other applications in my mac, such as textedit.

Using the Hyperlink process creation within Excel, seems to be automatically adding " file://localhost/ " at the beginning of my devonthink URL, therefore creating a non valid URL to access my document.

Any thoughts on this. Known workarounds?

Thanks,

 

[Jim Gordon MVP]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to create hyperlinks in an Excel sheet, to documents (pdfs primarily)

My documents are within a devonthink database, and the URL to access them start with " x-devonthink-item:// ".

I am able to reach into the document within my devonthink database, when entering or clicking in the URL link from other applications in my mac, such as textedit.

Using the Hyperlink process creation within Excel, seems to be automatically adding " file://localhost/ " at the beginning of my devonthink URL, therefore creating a non valid URL to access my document.

Any thoughts on this. Known workarounds?

Thanks,

Hi Orlando,

The first part of every hyperlink specifies the protocol to be used:
http:// means hypertext markup language to link to a web page
file:// means you will link to a file on your computer
mailto:// means you will create an email to the specified email address

Starting a URL with x-devonthink-item:// is nonsense to Excel, as there
is no such protocol.

In the middle of the Insert Hyperlink dialog box there is a series of
three buttons: Web Page/Document/E-mail address. It sounds to me like
you want to link to a document on your local computer, so click the
Document button. Then click the Select button and navigate to the file
on your computer or network. Excel will put the file:// protocol
indicator at the beginning of the link, and that is the correct
behavior. You can change it, of course, but the link will not work if
change it in an inappropriate way.

-Jim

 

[Bill W]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Consider having the text of the link address in a cell, and using an
AppleScript to grab the link address and open it, by-passing Excel's
interpretation of the address.