Hi,

I found the following thread by searching the internet http://www.excelforum.com/excel-prog...using-vba.html and used the code to carry out a web query.

I have 6 links in a worksheet entitled URL. The first time I used the macro it downloaded the table from each of the 6 links but subsequent times it has only downloaded the table from the first link but has done so 6 times.

I am no expert with VBA and was hoping someone may be able to point out where the issue lies. I have included the code below.

Thanks,

Andy

Please Login or Register  to view this content.