Excel Macro to update a external database connection - open to bidding

I have a excel document that has a macro which when run will modify a CommandText of that connection to pass in params from the excel spreadsheet. like so: code: [login to view URL] We would like the refresh to not only modify the connection command but also modify the connection as we would like to run for a different database also: screenshot: [login to view URL] Just like the macro replace the command params with values from the spreadsheet we would like it to also replace the database server name and database name from values from the spreadsheet. A complete implementation is not required, just the code to modify the connection with values from the sheet will be sufficient, I should be able to getting it working from there. Attached is the excel sheet. Obviously it wont connect to our server but hopefully you should be able to put the code in the right places and