Data connections in Excel 2010 and sql server 2008
 

Hi All, Im using data connections in excel 2010 and using an sql server 2008
database query in it.
My requirement is to change the data source name each and everytime I
refresh the data. For this I need to change data source value in connection
string and also need to change the values in sql query(i need to pass
parameters).

I request you to pls help me in resolving this.
Also your help is greatly appreciated if you would can give me a resolution
in excel 2007 instead of excel 2010.

Thanks in advance.
_Suresh.