Hi All,
  I am facing an issue. It would be great if
 any one of u can help me in this regard.

 Let me explain the issue.
 The issue is regarding accessing the excel data
 from the asp page.
 I am trying to qurey on the range present in the
 excel sheet.
 I am getting the data correctly. But I am not
 getting the hyperlinks associated with the cells in
 the excel page.

 I believe, this example will help you in
 understanding the issue.

 Example: This detail is there in the excel sheet
 sl. no. name
    1 abc -- suppose abc contains [email protected] as hyperlink
    2 xyz -- suppose xyz contains [email protected] as hyperlink

 Suppose "myRange" is the range created on the excel
 sheet.

 Now, I query from the asp page for the data. I am
 able to get the data properly.
 query:: "SELECT * FROM myRange"
 But how to get the hyperlinks & associate the
 hyperlink with the data.
 Example: This is what expected on the report.
  sl. no name
  1 abc -- must contain a link to [email protected]
  2 xyz -- must contain a link to [email protected]

 The asp code is as below... what needs to be
 modified?

 ' assume that the objects are created & initialized as required

 strQry = "SELECT * FROM " & Application("range")
oRS.Open strQry, oConn ' oCOnn is the conn. object --assume its woking
  while not oRS.EOF
    Response.Write "<tr class=fieldtext>"
 for each fld in oRS.Fields
   Response.Write "<td align=left>" & fld.value & "</td>"
  next
  Response.Write "</tr>"
 oRS.MoveNext
  wend

 'end of code

 Thank you in advance for the help.

kind regards,
Sandeep :)

You need the value of the hyperlink not the value of the cell, unfortunately ADO returns the value of the cell. Two suggestions:

1. Use Office automation to open your Excel spreadsheet directly without using ADO. Then you can directly access all the underlying values of a cell. (i.e. Range("A1").Hyperlinks(1).Address)

2. If you insist on using ADO, set some hidden cells to contain the hyperlink address (This can be done with a macro on startup) and query that range instead.

Hi,
 Thank you for the reply.
 I am trying to achieve it by putting hyperlinks into other cells as u wrote using application object.
 It is working fine.
bye,
Sandeep