try ths
http://www.mrexcel.com/forum/excel-questions/548342-embed-password-visual-basic-applications-odbc-connection.html
On Wed, Feb 26, 2014 at 7:59 PM, pranav patil wrote:
> I have created an Excel sheet that retrieves data from a ODBC source. I
> have created a macro using macro recorder to
I have created an Excel sheet that retrieves data from a ODBC source. I
have created a macro using macro recorder to refresh the data by
re-connecting to the database. However, the connection requires a password
prompt and when the macro is run, you are still required to enter the
password.
I
