Using Parameters With Web Queries

Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97.

This article shows how you can setup a web query so that you can make the worksheet dynamically update based on values in so called parameter cells.

The article also shows how to programmatically change parameter settings.


Jan Karel Pieterse
JKP Application Development Services

Posted in Uncategorized

One thought on “Using Parameters With Web Queries

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.