Z
Zig Mandel
Im trying to create an hyperlink inside a result column from an sql query
inside an excel worksheet.
If I type the text manually into a cell, as in (example)
=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 doesnt work (it shows the
"=HYPERLINK..." text, instead of the friendly name text ("View"), but oddly
enough,
it shows underlined (so it shows that excel is trying to do something with
it). Futhermore, clicking it does nothing.
This appears to be a bug in excel.
Is there a way arround this?
Background info (not necessary but very interesting):
Iff this worked, it would be a powerful Excel feature (I cant believe nobody
has complained about this), 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.)
This allows developers to leverage the power of excel as the app's reporting
engine, while being able to comunicate both ways from app to/from excel.
Thanx for any help,
Zig Mandel
inside an excel worksheet.
If I type the text manually into a cell, as in (example)
=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 doesnt work (it shows the
"=HYPERLINK..." text, instead of the friendly name text ("View"), but oddly
enough,
it shows underlined (so it shows that excel is trying to do something with
it). Futhermore, clicking it does nothing.
This appears to be a bug in excel.
Is there a way arround this?
Background info (not necessary but very interesting):
Iff this worked, it would be a powerful Excel feature (I cant believe nobody
has complained about this), 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.)
This allows developers to leverage the power of excel as the app's reporting
engine, while being able to comunicate both ways from app to/from excel.
Thanx for any help,
Zig Mandel