A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlink to Internet dictionary lookup



 
 
Thread Tools Display Modes
  #1  
Old February 27th, 2004, 04:38 PM
Malcolm McClure
external usenet poster
 
Posts: n/a
Default Hyperlink to Internet dictionary lookup

I'm trying to create a hyperlink to an external internet dictionary =
lookup=20
from an Office:mac 2001 Excel spreadsheet. My spreadsheet cell A4 has =
the=20
hyperlink; A5 has the dictionary name; A6 has the word input field and =
A7=20
has the http address of the dictionary, which seems to allow direct =
input.=20
This address has the form:
http://www.hyperdictionary.com/search.aspx?define=3DX where X represents =

the word I want to input (left blank in my A7).
When I use the hyperlink text =3DHYPERLINK("[A7]A6",A5) in A4 it picks =
up the=20
name of the dictionary in A5 but when I try to activate the link I get =
the=20
srsreen message 'Microsoft Excel cannot open the specified file'.
Can someone please tell me what I am doing wrong?

  #2  
Old February 29th, 2004, 04:23 AM
David McRitchie
external usenet poster
 
Posts: n/a
Default Hyperlink to Internet dictionary lookup

Hi Malcolm,

A4: =HYPERLINK(A5&A6,A6)
A5: http://www.hyperdictionary.com/search.aspx?define=
A6: wired

Your dictionary is not an Excel workbook if that is what the square
brackets were for. I don't understand waht A7 was supposed to
do. The above works. Or perhaps you were looking for something like:

A4: =HYPERLINK("http://www." & A7 & ".com/search.aspx?define=" & A6,A6)
A6: wired
A7: hyperdictionary

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Malcolm McClure" wrote in message ...
I'm trying to create a hyperlink to an external internet dictionary lookup
from an Office:mac 2001 Excel spreadsheet. My spreadsheet cell A4 has the
hyperlink; A5 has the dictionary name; A6 has the word input field and A7
has the http address of the dictionary, which seems to allow direct input.
This address has the form:
http://www.hyperdictionary.com/search.aspx?define=X where X represents
the word I want to input (left blank in my A7).
When I use the hyperlink text =HYPERLINK("[A7]A6",A5) in A4 it picks up the
name of the dictionary in A5 but when I try to activate the link I get the
srsreen message 'Microsoft Excel cannot open the specified file'.
Can someone please tell me what I am doing wrong?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:55 AM.


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