radujit
10-24-2010, 04:15 AM
Let me tell you what I want to do: get external information from yahoo in csv format and then save it to my local.
Dim objXmlHttptemp
Dim strHTMLtemp
Set objXmlHttptemp = Server.CreateObject("Msxml2.ServerXMLHTTP")
sql="http://ichart.finance.yahoo.com/table.csv?s=%5EGSPC&d=9&e=24&f=2010&g=d&a=0&b=3&c=2005"
objXmlHttptemp.open "GET", sql , False
objXmlHttptemp.send
strHTMLtemp = objXmlHttptemp.responseText
as you may see at the address
http://www.iisconsult.ro/down.asp
the data is downloaded
Now my problem is when I want to split the HTML on blanks
I use split(strHTMLtemp," ") but nothing happens
Can you help me
Dim objXmlHttptemp
Dim strHTMLtemp
Set objXmlHttptemp = Server.CreateObject("Msxml2.ServerXMLHTTP")
sql="http://ichart.finance.yahoo.com/table.csv?s=%5EGSPC&d=9&e=24&f=2010&g=d&a=0&b=3&c=2005"
objXmlHttptemp.open "GET", sql , False
objXmlHttptemp.send
strHTMLtemp = objXmlHttptemp.responseText
as you may see at the address
http://www.iisconsult.ro/down.asp
the data is downloaded
Now my problem is when I want to split the HTML on blanks
I use split(strHTMLtemp," ") but nothing happens
Can you help me