View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Scrolling down a web page using VBA

See my answer to your earlier post.

Tim

"musicgold" <u40543@uwe wrote in message news:9d3389dfef3ce@uwe...
Hi,

I wish to be able to do the following things on a web page inside an
Internet
Explorer instance.
I would appreciate it if you could give me some guidance on that.

1. Scroll down or right on the page
2. Go to a specific location on the web page (say at a word or phrase),
scrolling down, up, right or left. I want the focus of the window at that
location.

I am using the following code to open a specific webpage. The IE window
does
NOT open in the maximized form. I want the page to automatically scroll
down
to the RATES section on the page.

Code:
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = 1
IE.Navigate "http://finance.yahoo.com/"
Do While IE.Busy: DoEvents: Loop


Thanks,

MG.