View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tech tech is offline
external usenet poster
 
Posts: 2
Default 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.