excel macro to change external data query connections

Asked Apr 06 '17 at 02:16

Active Apr 06 '17 at 02:51

Viewed 204 times

I found the following response and it looks like it could potentially work but as the last comment says, it breaks when running in excel 2013.

The spot that I am getting an error on is

odbcCn.Connection = ConnectionString

edited May 23 '17 at 10:30

Community

asked Apr 06 '17 at 02:16

SilentVanRetz

1

You can improve this question by adding the code you adapted from the other question. – Robin Mackenzie Apr 06 '17 at 03:07
what error are you getting? – AlwaysData Apr 06 '17 at 03:09

0 Answers0