Seeking Excel Macro to Switch Back-n-Forth between 32-bit and 64-bit ODBC based on machine

We have some users on 64-bit Excel and some on 32-bit Excel, and we have Excel files which use 32-bit ODBC to grab data. It's difficult to migrate all users to 64-bit Excel, so I was wondering if there's a good mechanism within VBA to have a macro change which ODBC connection is to be used for the data.

Thanks in advance!