Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem (bug?) using =HYPERLINK in database query column?
Im trying to create an hyperlink inside the results from an sql query.
If I type the text manually into a cell, as in: =HYPERLINK("HTTP://www.slashdot.org", "View") it works fine (that is, it shows as "View" underlined, just like a hyperlink, and when I click it, it opens the browser. However, if this text is the column text of an SQL query (by using the Database Query feature) , it displays incorrectly (it shows the "=HYPERLINK..." text, instead of the friendly name text, but oddly enough, it shows underlined. Futhermore, clicking it does nothing. This appears to be a bug in excel, because in some (rare) ocassions, it does display and work correctly. Is there a way arround this? Note that this, if it worked, would be a powerful feature, because one could register a custom URL protocol handler (in fact this is what I want to use it for, the http is just to simplify the question to this newsgroup), and be able to "drill down" from the excel report into the application that generated that data, by generating the appropiate url from SQL (for example, in my case a URL looks like "TAOF://History/14/34", and when clicked, my app will get that string as a command-line parameter (see for example This allows developers to leverage the power of excel as the app's reporting engine, while being able to comunicate both ways from app < -- excel. Thanx for any help, Zig Mandel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Excel query of Postgress database - schema case problem.. | Excel Discussion (Misc queries) | |||
column aliases dropped with database query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) |