We are trying to create a macro that will download a table from an ODBC source that is protected by a password. We are trying to figure out a way to store the password in the code so that it will not prompt us when the macro is run.
Is there any place to put the password within the ODBC statement?
"ODBC;DSN=SOLARIS_QUERY_ENVIRONMENT;Description=SOLARIS_QUERY_ENVIRONMENT;UID=audit;;APP=2007 Microsoft Office system;WSID=XXXXXXX;D" _
), Array("ATABASE=XXXXX;Network=XXXXXXXX")), Destination:=Range("$A$1")). _
Thanks in advance!
Is there any place to put the password within the ODBC statement?
"ODBC;DSN=SOLARIS_QUERY_ENVIRONMENT;Description=SOLARIS_QUERY_ENVIRONMENT;UID=audit;;APP=2007 Microsoft Office system;WSID=XXXXXXX;D" _
), Array("ATABASE=XXXXX;Network=XXXXXXXX")), Destination:=Range("$A$1")). _
Thanks in advance!
