Hi Jack,

I know the objDocument does contain the data as I can
check the size of the variable to which it returns a
largeish value

The easiest way to find your way around the object model is to step
through the code with the Locals window showing. Once you've opened the
URL and allowed the content to download, expand the objDocument node to
see it's contents. Hopefully, one of the properties will expose your
csv data.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk