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