I was just wondering if there is a way to bypass creating .iqy files
in performing web queries in Excel 97. I have to download tables from
200+ websites, whose name only differs by 1 number (for example,
www.website.com/1.html, www.website.com/2.html, etc).

As far as I can see, in order to do this I have to create 200+ .iqy
files to be referenced within a macro. I have a VB code that makes
referencing easy, but the problem still lies with creating each single
..iqy file. Is there some way to perform a web query in Excel 97
without referencing these .iqy files? Some VB code that does the same
trick?

Thanks.

Turn on the macro recorder and then Do
Data=Get External Data = New Web Query

and query one of your sites.

This should show you how to pass the target as a string to the query
commands. You can then build this string dynamically in a loop and automate
your web queries.

--
Regards,
Tom Ogilvy

"JW" wrote in message
om...
I was just wondering if there is a way to bypass creating .iqy files
in performing web queries in Excel 97. I have to download tables from
200+ websites, whose name only differs by 1 number (for example,
www.website.com/1.html, www.website.com/2.html, etc).

As far as I can see, in order to do this I have to create 200+ .iqy
files to be referenced within a macro. I have a VB code that makes
referencing easy, but the problem still lies with creating each single
.iqy file. Is there some way to perform a web query in Excel 97
without referencing these .iqy files? Some VB code that does the same
trick?

Thanks.