Hi Friends,

I need to write a web query which is .iqy file where in the date is taken dynamically. I wish to give the date in cell a1. The code should pick up the date from the a1 cell fills that in the date part and open the website automatically.


Rollup.html?siteId=390&maxDate=04/03/2007
&intervalType=Daily&useLiveData=0&runReport=1&
textMode=1&scheduleId=


This site wont work for you since its a intranet site. Any ideas how to make the code in the .iqy file pick up the date from cell a1 in the excel sheet.

Please help