Excel 2007 : Help with Internet links and Excel

[zwalter]

Hi everyone,

I'm trying to create a spreadsheet that has info for some stocks I'm tracking. I know how to get the quotes from MSN MoneyCentral Investor Stock Quotes, so that is not an issue I'm having. The issue I'm having is gathering data that is not available through that MSN MoneyCentral Investor Stock Quotes. I know how to pull info from sites like Google Finance or Reuters, but is there a way to pull information such as the "approximate next earnings" for each of my stocks without doing it for each stock manually?

What I did for one stock
-> Data -> From Web -> then go to Reuters.com then search for AAPL before pulling the table of the data I want.

I guess my main question is there a way to have excel do what I did above, but automatically search for cell B5 and pull the data?

I really appreciate anyone that could help.

Thank you,
Zwalter

[zwalter]

Bump....

Can anyone help or am I asking for something that excel cannot perform?

[NickyC]

It should be possible if the data you want to import is always found at the same address on the web. I don't think you can automate a download that requires a search, though.

[zwalter]

It should be possible if the data you want to import is always found at the same address on the web. I don't think you can automate a download that requires a search, though.

It would require a search. Thank you for your response.