If you download the cache data files from the
Snaptek site (as always, thanks Brian and Jason!) and import them into Excel
2000 or Excel 2002 (XP), here's a formula that will generate a hyperlink to the
web page for any cache in the listing.
In the first blank column (Column "I" in the "az_caches_team" file, Column
"G" in the "az_caches" file) of Row
2, enter the following formula:
=Hyperlink("http://www.geocaching.com/seek/cache_details.asp?ID="&Hex2Dec(Right(C2,4)))
It will evaluate to the Web link of the cache
that has its waypoint listed in cell C2. You should then be able to click on it
and, assuming you are connected to the Internet, automatically open a browser window containing
that cache's web page. Once you've checked that the formula is working, you can drag that formula down all the rows of the
list, and generate a hyperlink for each line.
If you enter this formula and get an Excel #NAME?
error, you probably need to install and/or enable the "Analysis ToolPak" Excel
add-in. Go to "Tools, Add-ins" on the Excel menu bar.
You can actually use this formula to convert a
waypoint in any spreadsheet into a link. Just replace "C2" in the above formula
with the cell address that contains the waypoint. As the formula is written, the
waypoint must be six characters in the format GCxxxx. To illustrate, the
waypoint must be in the cell as GC0057 not GC57.
Hope you find this useful.
Steve
Team Tierra
Buena