I think the excel web connectivity kit has examples. http://office.microsoft.com/downloads/9798/webcnkit.aspx
yeah it does. quick test for ya. Here is my URL with data. http://www.rivercityhockey.net/schedule.cfm?fo=hockeyschedule&method=standings&division=A:%20Budweiser%20Division I have IDed a table using ID=standings ie <table id=standings> The cfm page accepts division=divisionname to filter the standings. Divisions A: Budweiser Division B: Fort Garry Lite Division C: Blue Division D: Labatts Lite Division I'll create a spreadsheet that gets the ID=standings table unformatted from the above address - and send the division as a parameter. Here are the steps. Hopefully they make sense. Open Excel. Type in A1. Division Type in A2. D: Labatts Lite Division (note: you could create a drop down list) Yeah lets do that. Create the list. Go to Sheet 2. copy the following to A1:A5. Name the range A2:A5 - "divisions" Divisions A: Budweiser Division B: Fort Garry Lite Division C: Blue Division D: Labatts Lite Division Back to Sheet 1. Click on A2. Data.Validation. {Select List}.{Souce "=divisions"} go to A4. Data.Get External Data.New Web Query. the URL. http://www.rivercityhockey.net/schedule.cfm?fo=hockeyschedule&method=standings&division=["DIVISION","Please enter the division."] Radio Option. One or more tables. Type in standings OK. It will prompt for the parameter location. go get it ot type in A2. Check off both checkboxes: Use this value for future refreshes. and Update on Change. [ok] Now you have a select list in Excel which automatically refresshes data in the spreadsheet based on the input. I am using Excel 2000 - but same thing possible in 97. HTH. Eric From: Thane Sherrington <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Excel Web Queries Date: Thu, 09 May 2002 13:37:26 -0300 I'm setting up web queries to pull data from pages created with CF, but my problem is that I can't create dynamic queries (I can pass the URL with URL variables, but I have no way to allow the user to enter different variables.) Anyone know how to do this? T ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
