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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|