I want to download some data from the web which is in a
simple table format (7 columns x 50 rows). I use MS Web
Query to do this.

Is there anyway that I can use VBA to just download the
first row of the table? Web Query only allows the whole
table to be downloaded and I cannot find a way to edit
this using Excel to just get specific bits of data.

As always, advice is well received...