Controlling IE from Excel

Hi All,
I am trying to open an intranet report from within a macro in Excel, then I
would like to 'Select All' and 'Copy' the data in the report, so I can paste
it into a new Excel spreadsheet.

I've tried sending a "^A" using DDE, but IE did not seem to recognise it.

The other problem I have, is that the report consists of 3 frames and the
correct part of the report must be clicked before the Select All will work
successfully.

Is this sort of thing best done by some sort of scripting language/package
that records mouse position and clicks? If so, which one would you
recommended?

With thanks,
Chris

Hi Chrispy,

> I am trying to open an intranet report from within a macro in Excel, then I
> would like to 'Select All' and 'Copy' the data in the report, so I can paste
> it into a new Excel spreadsheet.
>

You can use the Workbooks.Open command directly to open the webpage in Excel
itself, or alternatively you can use Data, get external data, new web query to
extract the data manually once, and then use the refresh method to update the
sheet with the latest data:

ThisWorkbook.Worksheets("Data").QueryTables(1).Refresh

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com