Need to update multiple ODBC connection strings HELP!!!

Does anyone have a script that will update multiple worksheet db connections with new connection strings? like a prompt for user input to the new database, file name, etc...? I have been trying to get the following code to work, but have not had any luck.

Please Login or Register  to view this content.

i was able to modify the script to make the connection string updates (I had an extra End Function
in there...), but now I need to update a static PATH value in the CommandText. Example Below:

Command text:

Please Login or Register  to view this content.

Need to be able to write MACRO to replace the PATH and retain the rest of the CommandText AS IS...