Hello,

I was wondering if it is possible for me take the datetimepicker date value
and execute a SQL query based on that variable? I am using VSTO 2005 and
Excel 2003 and have a data source hooked up to a column (with an initial
query already specified), I need to pick the date from the datetimepicker
control and have it update the query so as to re execute the query based on
the date (which, of course corresponds to an index table named 'row_date').

Thank you for your help.

Paul

Paul,
Check the Excel Help for "parameter_query".

NickHK

"Paul Shoemaker" <Paul wrote in message
...
Hello,

I was wondering if it is possible for me take the datetimepicker date
value
and execute a SQL query based on that variable? I am using VSTO 2005 and
Excel 2003 and have a data source hooked up to a column (with an initial
query already specified), I need to pick the date from the datetimepicker
control and have it update the query so as to re execute the query based
on
the date (which, of course corresponds to an index table named
'row_date').

Thank you for your help.

Paul