I am using Excel to run a query against a SQL database.
One of the colums that is being returned is a web site
address (e.g., http://www.mywebsite.com)
Is there any way to format the column so that the data
being returned becomes a live hyperlink rather than just a
text string of the web site address?
Thanks
.
There is a worksheet function called hyperlink.
if the cell B1 contains the value:
=Hyperlink("http://www.mywebsite.com")
It will be a link.
So to get the whole column as a link, you would have to
structure your SQL query so that you get back the result
in the format:
=Hyperlink("http://www.mywebsite.com")
If the query is automatic and you cant change the format
in which the results come, I would suggest that you just
have another column with a formula using the Hyperlink
function.
For eg: if column B has your URLs, then, say in, column F
you could have a formula where
F1 =Hyperlink(B1)
F2 =Hyperlink(B2)
and so on...
Hope that helps.
Sanjay V
Sanjayva at yahoo dot com
>-----Original Message-----
>I am using Excel to run a query against a SQL database.
[quoted text clipped - 10 lines]
>
>.
Jamie Collins - 28 Sep 2004 08:49 GMT
> There is a worksheet function called hyperlink.
>
[quoted text clipped - 7 lines]
> in the format:
> =Hyperlink("http://www.mywebsite.com")
How would this work? The query results would be interpreted as text
(e.g. a leading apostrophe would be added). How would it be recognized
as a formula?
Jamie.
--
David McRitchie - 28 Sep 2004 16:44 GMT
Hi Art ,
big time waster asking in more than one Excel newsgroup, see another
reply to Art's question in the programming newsgroup:
http://google.com/groups?threadm=elm6p%23LpEHA.744%40TK2MSFTNGP10.phx.gbl
---
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
"Jamie Collins" <jamiecollins@xsmail.com> wrote in message
> How would this work? The query results would be interpreted as text
> (e.g. a leading apostrophe would be added). How would it be recognized
> as a formula?