Programaticaly update webquery - help
 

Hi,

I would like to be able to programaticaly change some of the parameters
in an webquery. For example if I have a webquery that uses
www.somesite.com?day=1&month=2, when I access my workbook the next day
and refresh the data it will load the previous days data. So I need some
way to change the parameters of the query to
http://www.somesite.com?day=(=date.d...date.mont h);

Could someone point me to a website that might explain how to program
Excel to do this automatically when the workbook is opened?

Thank you
Paul