That should read "...so Excel cannot parse... "

NickHK

"NickHK" wrote in message
...
You can use an Excel web query, but make sure you select the "Entire Page"
option.
I'm not HTML expert, but it looks like the data is not really in a table
but
in DIV/SPAN tags, so Excel can parse it as it in TABLE/TR/TD tags.
You'll have to do work then to get the data separated.

NickHK

"user88" wrote in message
...
Hi,

I have tried this also, I don't see the data from the webpage.

How to resolve?


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.