Dynamic web query - Can this be done?

[Anthon]

Hallo

I want to automate 2 web query's with a macro or vba code for 1. a web site
that changes the date in its internet address everyday and 2. a web site that
changes the data codes in its internet address.

I have used ["DATE?"] in my query but then it asks me manually to load the
information.

I want to use a cell with this information and let the query find it
automatically, how do I add this manual function which ["DATE"] produces,
into my macro or vba code.

Thanks
Anthon