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.