I have an excel file with several queries.
This is connection string.
It is saved in Excel file UID and PWD.
I can see it using this macros.
http://support.microsoft.com/kb/330383/en-us
Connection -- ODBC;DRIVER={Oracle73 Ver
2.5};UID=MYNAME;PWD=MYPASS;DBQ=PROD;ASY=OFF;
CommandText -- SELECT USERS.NAME FROM SCHEMA1.USERS
How to update CommandText SCHEMA1 with SCHEMA2 in above query?