Hello,

I have an excel which is connecting to the sqlserver. I have provided the connectionstring in the Module.

What i need now is, the connectionstring needs to be dynamic.

We need to provide a interface for the end user to provide the connectionstring details.

the excel file has a macro which does not allow the excel file to be saved.....

Regards
Rajeesh