Getting external data...
 

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...

Getting external data...
 

It is not necessary to multi post to more than one ng

--
Don Guillett
SalesAid Software

"Alex" wrote in message
...
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...