Possible to send parameter to Excel (via Web) to pas along through to SQL Server?

Is there anyway to pass a parameter to an Excel spreadsheet (loaded in a browser) to use as a parameter in SQL statement?

I know that the Microsoft Technologies can write Excel files and then load them, but I'm looking to take an existing workbook, parameterize the SQL statement and pass parameters via the Querystring/Form Post to it.

Why you may ask? For existing PivotTables/Charts that can be filtered BEFORE they are run.

Any/all thoughts appreciated.

BobYeah, there's a lot you can do. Check out this KB article for some ideas and code:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934|||What I'm looking to do specifically is to have a "template" of a workbook that I will pass connection/SQL Query information to, to be displayed on the fly.

Example:
A Pivot Table show results of: SELECT * FROM Products WHERE ProductID = <parameter
Web page passes a ProductID and the query is run (with the filter).

I'm assuming that I will have some sort of VBA code to hold the CORE query and I would like to be able to pass the parameter via ASP.

Any additional thoughts?

Thanx,
Bob|||Ok, I think I understand what you're trying to do. I believe this article shows you how (see the Generate XML from a Dataset for use in Excel 2003 section):

http://msdn.microsoft.com/office/understanding/excel/technicalarticles/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/odc_xltransferxmltoxlwvb.asp

Possible to override browser language setting?

this snippet:
The browser language setting is the primary factor in determining which
language resource is used by the report server for that client connection.
For example, a user who accesses a Japanese report server using a French
version of Internet Explorer will work with French versions of Report
Manager, HTML Viewer, and the report server folder namespace. In addition,
all errors, warnings, and informational messages will be returned in French.
is from this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0vaa.asp
Is it possible to override this for reporting services? I have a user
locale setting in a DB that I would like to use instead of the browser or OS
settings. I can deliver the reports in the proper locale by passing a
parameter, but the settings for the web service still behave according to the
browser settings, as the snippet above describes. In fact, I have a date
format clash that I am not sure quite how to resolve.
Thanks in advance, any help will be very much appreciated.I can solve the date clash by formatting the datetime parameters according
to the browser's setting, but this does not really solve my problem because I
don't want things like selection of report export formats to be in the
browser's language, I want to set the culture information (from a user
profile in a DB).
Thank you again, I am looking forward to your feedback|||regarding my post on whether the locale used for things like the export
options can be set manually rather than pulled from the browser...
I think this will be an easy question to answer for someone on the
development team or simply someone more familiar with microsoft
internationalization than myself.
Thank you very much, in advance.
skillet