Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling IE from Excel
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).Ref resh Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling an application from excel vba | Excel Programming | |||
Controlling Access from Excel | Excel Programming | |||
Controlling Word from Excel | Excel Programming |