Web Qery Based On Form Field Input
 

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

Web Qery Based On Form Field Input
 

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


--
Don Guillett
SalesAid Software

"netbrink" wrote in
message ...

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

Web Qery Based On Form Field Input
 

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


--
netbrink
------------------------------------------------------------------------
netbrink's Profile: http://www.excelforum.com/member.php...o&userid=33501
View this thread: http://www.excelforum.com/showthread...hreadid=533166

Web Qery Based On Form Field Input
 

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).