Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Question
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Question
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Question
Post the url for the website and the url for the portion of the website you
want. Try right clickimport to excelmake 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. -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ups.com... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Question
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/ex...346091033.aspx Good luck Marcus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
one more macro question | Excel Programming | |||
macro question | Excel Programming | |||
Macro Question | Excel Programming |