Macro / VBA to update connection string to different SQL Server

[staggerlee011]

Hey all,

we have a whole bunch of sql server instances that have the same database and table, id like to be able to update my excel spreadsheet which connects to it via a macro instead of manually going in and changing the server each time. its windows auth all the way, if that helps simply things. Any suggestions for where to get started?

s