| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retreving data from Web page
Hi,
http://www.investor.reuters.wallst.c...asp?ticker=IBM Trying to retrieve specific info from the web page. ie: EPS (TTM) vs TTM 1 Yr. Ago I can't seem to retrieve any data from the page, I have tried using the following: #1: 'Microsoft.XMLHTTP, MS COM object to retrieve data from another website via HTTP requests Set xmlhttp = CreateObject("Microsoft.XMLHTTP") #2: Set oIE = New SHDocVw.InternetExplorer 'Open the web page oIE.Navigate "http://www.investor.reuters.wallst.com/stocks/Ratios.asp?ticker=IBM What is the best way to retrieve the data from this page? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to change page # when data entered in other page | Excel Discussion (Misc queries) | |||
| How do I copy a graph of a data page to a new data page. | Charts and Charting in Excel | |||
| Page Break Preview Page Number as Data | Excel Programming | |||
| excel fit to 1 page shows 1 page but not all data is on that page | Excel Programming | |||
| Printing second page if data overruns, otherwise print first page | Excel Programming | |||
Threaded Mode
