PDA

View Full Version : Solved: Getting data from web site



Tenspeed39355
06-02-2008, 11:48 AM
Hi guys. This is a good one. Here is the plan. I would like to download
data from a Yahoo site. I am using Excel 2007. I can go to the Data Tab,then chose From the Web, Next I can type in the web page I need.
Hightlight the arrows for the data I need. Select Import at the bottom of the screen. Then at the ss the data is imported. All this is for just one (1)
symbol. Lets say I want to import the data for 50 symbols. Is there a way
to do that. This might take several times but lets start with this.
Thanks for your time with this.
Max

stanl
06-02-2008, 01:37 PM
You best start is to record a macro for extracting data to a single page [let's assume you want Yahoo stock quotes]. Next use that code a template, create a lookup range of the URL's and then construct a loop to create separate worksheets for each web-query; then if you like the tricky part use the first sheet in the workbook to create a TOC to reference the other sheets. Stan

Tenspeed39355
06-02-2008, 06:52 PM
Thanks I can take it from here, thanks
Max