Extracting data from specific cells on open excel sheet

[animelover72]

Hi,
I currently have a button which converts the current asp.NET page I'm on into an excel sheet. This is the code for it :

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
recordsSearch.visible = false
Button1.visible = false
Page.EnableViewState=False
Response.ContentType="application/vnd.ms-excel"

The data that i want to use is in cell C5.
How can i extract that value?

any suggestions welcomed ^^

 

[send2te]

{Be hAppy}

msgbox ActiveWorkBook.ActiveSheet.Cells(5,3).Value

Give a little bit more code if you want the correct solution.