P
Paul
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
www.somesite.com?day=(=date.day)&month=(=date.month);
Could someone point me to a website that might explain how to program
access to do this automatically when the workbook is opened?
Thank you
Paul
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
www.somesite.com?day=(=date.day)&month=(=date.month);
Could someone point me to a website that might explain how to program
access to do this automatically when the workbook is opened?
Thank you
Paul