Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

Hyperlinks

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Art - 27 Sep 2004 18:53 GMT
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
.
Sanjay Valiyaveettil - 27 Sep 2004 20:15 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.