VBA Macro Question

[tmoon827]

I was wondering if anyone new how to do this:

I'm making an excel spreadsheet, and I want to import data from the
web. But I would like a formula that basically says, "go to this
website, and give me the number that comes after "stock price"" or
something of that sort. Does anyone know how to do formulas such as
this? I would greatly appreciate the help. Thanks

 

[marcus]

You could try the Web Query. This imports the data from a web page
and is very good at returning stock prices.

Data - Import External Data - New Web Query.

Go to the web page you are interested in and use the prompts to return
the desired bit of information.

Let me know if you need any further information. Hope this helps.

Regards

Marcus

 

[tmoon827]

Hi,

Thanks Marcus, but I need to do it for 9000 items. So thta would be
almost impossible to get the web query for each stock price.

Do you know of any formulas that answer the same question?

Thanks.

 

[Don Guillett]

Post the url for the website and the url for the portion of the website you
want.
Try right click>import to excel>make an external query and use a FIND macro
to find what you want.
If all else fails,send me a workbook to the address below along with details
of what you want.

 

[marcus]

Hi

This kind of looks like what you are after but you have to go to
microsoft to add this in.

http://office.microsoft.com/en-us/excel/HA010346091033.aspx

Good luck

Marcus