script to search web and put result in Excel

I am trying to write a script to search yahoo finance web page and put the result into a excel spreadsheet.
Here is what I want to do:
The first column is the list of the stock ticker I manually put in, then I can run a macro to URL, then grab the data for anual EPS, current quarter EPS, and put them into the spread sheet.
Anybody have idea how to do it?
I don't have any knowledge of the script, if anybody can point me to some similar example script on the net, that will be great. Thanks!