We have an Excel tool coded with MS Query and macros. The current macros include the table owner name and running the macro automatically points to an old enviroment.
1. I now need to point to a different environment (for simplicity say Dev to Prod). do I need to modify each Query to point to prod? or is there a way I can insert connection code to overwrite the current connection?
2. My database is an AS400, so the library the tables live in change from QA to OTHER. Normally on the AS400 we don’t specify library names, but MS Query seems to want to default to my personal library instead of using the AS400 library list. Do I have to update all the macros and the MSQueries to make the change? or is there a simply way to adjust all the queries in the tool.
Thanks!
