Nice Bob, I would have probably gone down the API route of DownloadURL.
I was commenting more on the fact that the post was in Formula not VBA so an intermediate level person could manage with switching on the macro recorder but query tables and API calls probably way too advanced.

I picked up on the thread title, web query, I took it literally and I used that approach. ALthough I put the required week number in a constant, it could of course easily be modified to pick that up from a cell.

With APIs, with the possibility of 32bit or 64bit Excel, API calls have to cater for this.