Get Data From Web Page

[termolist]

Hi,

I want to get data from a web page http://finans.mynet.com/cb/canliyayin.asp with excel. I try web query but the page does not get any data. I think the web page uses ajax. Is there any solution to get from this site with excel and/or vba.

Thanks

 

[Sektor]

Declare Function URLDownloadToFile Lib "urlmon" Alias _
     "URLDownloadToFileA" (ByVal pCaller As Long, _
     ByVal szURL As String, _
     ByVal szFileName As String, _
     ByVal dwReserved As Long, _
     ByVal lpfnCB As Long) As Long


 Function DownloadFile(URL As String, LocalFilename As String) As Boolean
     Dim ret As Long
     ret = URLDownloadToFile(0, URL, LocalFilename, 0, 0)
     If ret = 0 Then DownloadFile = True
 End Function

 Sub DownloadFromSite()
     
     Dim sURL    As String
     Dim sLocalFilename   As String
     
     sLocalFile = "C:\1.asp"
     sURL = "http://finans.mynet.com/cb/canliyayin.asp"
     
     Debug.Print DownloadFile(sURL, sLocalFile)
     
 End Sub

 

[Norie]

There is no data to get from the page that URL points to.

The page is generated through ASP, I don't think AJAX is involved.

If there was data of some sort there are various ways you could try to get it.

Which to use it's pretty hard say which to choose.

PS Isn't that address for some sort of log in page?