How can I control the mouse pointer by the Excel VBA?
I want to use the mouse to click on the IE pages to do the copy and paste
for getting the required information into my excel worksheet.

What about use a web query or automating IE instead ?

NickHK

"trader" <(E-Mail Removed)> wrote in message
news:FC1CB09A-1761-4EF0-8784-(E-Mail Removed)...
> How can I control the mouse pointer by the Excel VBA?
> I want to use the mouse to click on the IE pages to do the copy and paste
> for getting the required information into my excel worksheet.
>

May I know how to do this by both methods?


"NickHK" wrote:

> What about use a web query or automating IE instead ?
>
> NickHK
>
> "trader" <(E-Mail Removed)> wrote in message
> news:FC1CB09A-1761-4EF0-8784-(E-Mail Removed)...
> > How can I control the mouse pointer by the Excel VBA?
> > I want to use the mouse to click on the IE pages to do the copy and paste
> > for getting the required information into my excel worksheet.
> >
>
>
>

May I know how to get the data by both the methods?
Actually, the data may not be obtained by web query. I failed to do this.
That's why I try to do it in another "stupid" way by controlling the mouse
to copy the data into my worksheet.

The data I needed may be created by java in the web. I need to click
buttons on the page to display the data.

"NickHK" wrote:

> What about use a web query or automating IE instead ?
>
> NickHK
>
> "trader" <(E-Mail Removed)> wrote in message
> news:FC1CB09A-1761-4EF0-8784-(E-Mail Removed)...
> > How can I control the mouse pointer by the Excel VBA?
> > I want to use the mouse to click on the IE pages to do the copy and paste
> > for getting the required information into my excel worksheet.
> >
>
>
>

Web query:
Data>Import External Data>New Web Query>follow the steps

Automating IE:
http://www.mvps.org/access/modules/mdl0062.htm
or Google for "Automating IE VB -Net".

NickHK

"trader" <(E-Mail Removed)> wrote in message
news:BF729F45-3239-4826-B911-(E-Mail Removed)...
> May I know how to do this by both methods?
>
>
> "NickHK" wrote:
>
> > What about use a web query or automating IE instead ?
> >
> > NickHK
> >
> > "trader" <(E-Mail Removed)> wrote in message
> > news:FC1CB09A-1761-4EF0-8784-(E-Mail Removed)...
> > > How can I control the mouse pointer by the Excel VBA?
> > > I want to use the mouse to click on the IE pages to do the copy and
paste
> > > for getting the required information into my excel worksheet.
> > >
> >
> >
> >