Sorry Walter, I didn't understand any of that (I struggle to get my head around IE automation at the best of times).

I've looked at the source code, it turns out I need to go to the URL, and copy all into an Excel sheet (for a ID number 1 to 1000) because its a Javascript table which looks up the table on the internal server.