Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling down a web page using VBA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling down a web page using VBA
can you proivethe detail link address.
I wish o learn the skill from you. "Tim Williams" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrolling down a web page using VBA | Excel Programming | |||
Row Scrolling with a Page | Excel Discussion (Misc queries) | |||
stop page totals creeping up page when scrolling | Excel Discussion (Misc queries) | |||
Scrolling excel page using down and up arrow | Excel Discussion (Misc queries) | |||
How do I go from one page to another in excel without scrolling? | Excel Worksheet Functions |