View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Retrieving data from Web page 2

The methods you show are valid, but again you have provided no details of what you've tried and exactly in what way they didn't work
for you...

How/where are you trying to "see" the data?

--
Tim Williams
Palo Alto, CA


"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.