vba - excel macro to change external data query connections -

i found following response , looks potentially work last comment says, breaks when running in excel 2013.

excel macro change external connections

the spot getting error on

odbccn.connection = connectionstring