[Ham-Computers] HYPERLINKING WITH EXCEL

Tue Jul 14 16:44:33 EDT 2009

Yeah, I have no idea what version of Excel that function first appeared in.  I have an MSDN subscription because of my work, so I have latest and greatest of everything.  I have to be careful with some things - doing "save as... earlier version" or my friends can't open files I create.

Glad it got you going.

73,
Jay

--- On Tue, 7/14/09, Ed - K9EW <k9ew57 at gmail.com> wrote:

From: Ed - K9EW <k9ew57 at gmail.com>
Subject: Re: [Ham-Computers] HYPERLINKING WITH EXCEL
To: "Computers (or other) used for amateur radio, communications, or experimenting" <ham-computers at mailman.qth.net>
Date: Tuesday, July 14, 2009, 5:51 PM

Hi Jay,

It works!

Now for the details...  I tried it on my spreadsheet, and it didn't
work.  I kept getting an HTTP/1.0 404 error message.  I kept tweaking
things, hoping for results, but nothing.  Then I had a breakthrough
idea... maybe my old Excel '97 just didn't have that capability (I
should have mentioned that in my original post).  So I switched to the
Open Office Spreadsheet, and tried your suggestion again.  And it
works great!  I'm sure the newer (than 1997) versions of Excel would
work also.

Now I can click on the cell next to the callsign on my spreadsheet,
and find the address for that person on QRZ.  Really slick!

Thanks very much for showing me (and probably some others on the List)
how to do that.

73,
ed - k9ew
www.k9ew.us

On Mon, Jul 13, 2009 at 10:23 PM, James B<24.driver at gmail.com> wrote:
> When I create a Hyperlink in Excel there are 2 parts to creating the hyperlink
>
> At the top of the create hyperlink box it says "Text to Display" where
> I enter the call sign - Example: n2xyz
>
> And at the bottom is the address box where you would enter the URL -
> Example: http://www.qrz.com/db/n2xyz
>
> Click OK and then just the Call Sign is displayed in the box but it is
> a link to the qrz page of that call sign.
>
>
>
> On Mon, Jul 13, 2009 at 10:54 PM, Ed - K9EW<k9ew57 at gmail.com> wrote:
>> Hi James,
>>
>> The "calletters" is the part I don't know how to do automatically.  I
>> created a hyperlink in the cell that contains the calletters of the
>> station worked, but I want to click on that cell, and have it go to
>> http://www.qrz.com/calleters, where calletters is the text in the
>> cell.  How do I do that with a click of the mouse?
>>
>> -ed
>>
>> On Mon, Jul 13, 2009 at 8:58 PM, James B<24.driver at gmail.com> wrote:
>>> Yes, enter the hyperlink URL as
>>>
>>> http://www.qrz.com/db/callletters
>>>
>>> Where callletters is the call sign of the station worked
>>>
>>>
>>> On Mon, Jul 13, 2009 at 6:46 PM, Ed - K9EW<k9ew57 at gmail.com> wrote:
>>>> Hi to the group.  I'm part way to a solution, but need some help.
>>>>
>>>> I have an Excel spreadsheet that I use for logging.  In one of the
>>>> cells I enter the callsign of the station worked.  Once the
>>>> information is entered, I would like to click on that cell, and have
>>>> Excel take me to the QRZ.com page with the information about that
>>>> operator.
>>>>
>>>> I can get as far as clicking on the callsign cell and winding up on
>>>> QRZ, but once I'm there, I have to enter the callsign manually (like
>>>> you would normally use QRZ).
>>>>
>>>> Does anyone know how to make that last step automatic?
>>>>
>>>> tnx es 73,
>>>> ed - k9ew
>>>> ______________________________________________________________
>>>> Ham-Computers mailing list
>>>> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
>>>> Help: http://mailman.qth.net/mmfaq.htm
>>>> Post: mailto:Ham-Computers at mailman.qth.net
>>>>
>>>> This list hosted by: http://www.qsl.net
>>>> Please help support this email list: http://www.qsl.net/donate.html
>>>>
>>> ______________________________________________________________
>>> Ham-Computers mailing list
>>> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
>>> Help: http://mailman.qth.net/mmfaq.htm
>>> Post: mailto:Ham-Computers at mailman.qth.net
>>>
>>> This list hosted by: http://www.qsl.net
>>> Please help support this email list: http://www.qsl.net/donate.html
>> ______________________________________________________________
>> Ham-Computers mailing list
>> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
>> Help: http://mailman.qth.net/mmfaq.htm
>> Post: mailto:Ham-Computers at mailman.qth.net
>>
>> This list hosted by: http://www.qsl.net
>> Please help support this email list: http://www.qsl.net/donate.html
> ______________________________________________________________
> Ham-Computers mailing list
> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Ham-Computers at mailman.qth.net
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
______________________________________________________________
Ham-Computers mailing list
Home: http://mailman.qth.net/mailman/listinfo/ham-computers
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Ham-Computers at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html