Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default 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).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Active X Controls Tabbing from Form Field 2 Form Field Tfrup12 Excel Discussion (Misc queries) 0 February 19th 08 08:15 PM
input in number form is being multiplied by 1000 when i input. jweinograd Excel Discussion (Misc queries) 4 April 16th 07 11:18 PM
Trying to select a specific range based on the time value of user form input Jitranijam New Users to Excel 8 November 15th 06 12:52 AM
How can I have an input form to add a random no. to each input entry? saziz Excel Discussion (Misc queries) 2 January 25th 06 11:46 PM
CODE to select range based on User Input or Value of Input Field Sandi Gauthier Excel Programming 4 December 8th 03 03:22 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"