A for/next loop. How about the actual url and an your web query macro

--
Don Guillett
SalesAid Software

"Vijay Kotian" wrote in message
...
In Macros i would like to write web query to extract data which consist of
more than 1500 rows, In Visual Basic the tables are mentioned as under
.WebTables = "3"

How can i mention 1500 tables by writing FOR Next....

or any other alternative.