Web query:
DataImport External DataNew Web Queryfollow the steps

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

NickHK

"trader" wrote in message
...
May I know how to do this by both methods?


"NickHK" wrote:

What about use a web query or automating IE instead ?

NickHK

"trader" wrote in message
...
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.