Obtaining the hyperlink from an Excel cell?

[wluu]

Hope someone can help me with this one. I have an asp page that connects to an excel file and displays the contents of the file from a range that I set. In one of the columns however, the values of the cell contains a string which also is a hyperlink. I can grab the string value, however I am not able to obtain the hyperlink value of the string. Can this be done? Here is a sample of my code:

sDBQ = "DBQ=\\PathHere\excelfile.xls"
sConnect = "DRIVER={Microsoft Excel Driver (*.xls)};" & sDBQ
sSource = "SELECT * FROM Gadget_Data"
Set rs = Server.CreateObject("ADODB.Recordset&quot
rs.Open sSource, sConnect

The above is my connection to the file where Gadget Data is the range specified. I then make a for loop to display the value of each cell:

For each item in rs.Fields
Response.Write item.value & " "
Next
rs.movenext

Thanks in advance guys.

 

[Sysgrunt]

If your hypertext link already reads

http://...

, then try using:

-------------------------------
For each item in rs.Fields

Response.Write &quot;<A href= '&quot;&item.value&&quot;'>&quot;&item.value&&quot;</A>&quot; & &quot;<BR><BR>&quot;

Next
rs.movenext
-------------------------------

** Note that there are single & double quote marks used in the first part of the anchor. Single quotes are in bold.

 

[wluu]

sysgrunt, the item.value only pulls in the text value of the cell. ie. if the cell had hello in the text with a link to

http://www.blah.com,

item.value will write out hello only. I just don't know if it's possible to grab the

http://www.blah.com

value????