This is called a web query.

Click on DATA Import External Data New Web Query

This opens a mini-browser. Use it to navigate to Yahoo and the
financial info you want to collect. You'll notice little yellow
arrows...those represent sets of web data you can "grab".

When the data you want is onscreen, click on the arrow next to that
data and it becomes a green checkmark.

Click on "IMPORT" and point your spreadsheet to where you want this to
appear. Click on PROPERTIES to setup some extra parameters, like how
often the data should refresh from the web.

It's usually best to collect this info on a scrap worksheet, then use
cell references to pull info from it onto the sheets where you read it
laid out the way you want.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46783