Alternative to web query in Excel 97?

J

JW

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

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IQY File: Invalid Web Query 2
excel web query url problem? 2
Excel 2007 multiple Web Query problem! URGENT! 2
Microsoft Excel Web Query Connectivity Kit 1
Query file without copy inside Excel 2
Question on Web Query .iqy Control Variables 0
Retrieving data from a password protected web site 0
Web Query and table? 8

Top