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.