Specific Coding Question

[nassersyed]

Ok, this is a pretty specific question, but can't imagine that it hasn't come up before.

Ok, I'm trying to take data from a web page. I'm trying make an up-to-date sport score calculator. Trying to make it as real-time as possible. When the stats come up on yahoo sports for a given game (football/basketball), I want to take that updated information and paste it into my program, right now I'm making a mockup of it in excel. Is there a way I can program or make a macro that will take information from a webpage and paste it in to or incorporate in my software? I've seen some VB code of tabbing through pages or sections until you reach the cell you want. But was wondering if there was a way or what is the easiest/best way of accomplishing it.

Thank you in advance,
Nasser

[NeedHelp]

You can always have your Visual Basic or any other .NET program grab data from the spreadsheet although it would be easier to just grab the data from the website.

[TcM]

Well that can be done in visual basic.. all you need to know is the HTML code of that page that stores the results and then get it into VB. simple and it can be displayed withing a msgbox, textbox or whatever.

[Xyphos]

Fire up your project
Add Component > Inet(.ocx)
(you can google for source/reference for Inet component)
put the code for it to fetch the page on a timer, and parse the data/html as needed.

[TcM]

Yes a good summary of what I had in mind.. but I have the code to use (I think it is somewhere on my PC)

[GMailGuy]

Did you ever solve this problem?