Web Qery Based On Form Field Input

[netbrink]

I wanted to grab data from a site that has 3 variables :Name, Start Date, and End date in the URL.

Example:
http://www.domain.com/pick-history.c...DATE&to=ENDATE

How do i make 3 form fields and grab it from this unique url when they input those variables.

Any help would be gladly appreciated.


Thanks,
Brian

[Don Guillett]

try
" http://www.domain.com/pick-history.cgi?attribute=PickerId&value=" & name &
"&from=" & STARTDATE & "&to=" & ENDATE


--
Don Guillett
SalesAid Software
[email protected]
"netbrink" <[email protected]> wrote in
message news:[email protected]...
>
> I wanted to grab data from a site that has 3 variables :Name, Start
> Date, and End date in the URL.
>
> Example:
> http://www.domain.com/pick-history.c...DATE&to=ENDATE
>
> How do i make 3 form fields and grab it from this unique url when they
> input those variables.
>
> Any help would be gladly appreciated.
>
>
> Thanks,
> Brian
>
>
> --
> netbrink
> ------------------------------------------------------------------------
> netbrink's Profile:
> http://www.excelforum.com/member.php...o&userid=33501
> View this thread: http://www.excelforum.com/showthread...hreadid=533166
>

[netbrink]

How do i create the form with those fields to tell it to do a webquery

[Randy Harmelink]

You don't need a form. Just set up the web query in EXCEL. It will
prompt for the variables...

For example:

http://ogres-crypt.com/iqy/yahoo-current-quotes.iqy

Try "MMM,IBM" for the first prompt (Tickers) and "sl1" (symbol and last
price) for the second prompt (Yahoo data codes).