Hello,

We are upgrading our SQL Server to 2016 and I need help identifying a way to update the SQL Server Connection across HUNDREDS of workbooks, with out having to manually go into each workbook

What's Happening:
1) IP Address to SQL Server is changing
2) Password is changing

All workbooks that connect to the SQL Server need to have the following happen:
1) IP Address needs to be updated to reflect the new IP Address
2) Password needs to change
3) Username stays the same
4) all workbooks need to be refreshed

What I need help with:
1) A code, macro, or SOMETHING that can scan a directory of all files with a SQL Server connection and to mass update their connections (IP, Password and refresh)

never had to do anything like this before so I have no idea where to begin.

Thank you for your help!