Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ This post shows you how to dynamically work with data from a website in Excel. Introduction 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 Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/07/31/using-parameters-with-web-queries.aspx
Jul 31 2009, 06:36 PM