Hi,

>In the past the data was sent as XLS or CSV - now they've suddenly changed it to HTML. I suspect that once converted to XLS I can reuse the code I've already written for such.

Ah - I see. Makes sense if you were pulling it in from XLS before.
BTW I worked on bus and train stuff (but it must have been back about 1980) for the old MPTE (Merseyside Passenger Transport Executive)...

Regards,
Viv