title: how to specify database user credentials in a connection array string (Excel VBA)
body: <p>Please help in modifying the connection array string (Excel 2010) to be able to receive the input from a cell reference for fields <code>UID=;PWD=</code> and <code>Initial Catalog</code>.</p>
  
  <pre><code>.Connection= Array("OLEDB;Provider=MSDASQL.1;Persist Security Info=True;Extended Properties=""DSN=NZSQL;Database=consumerdb;Servername=192.54.97.102;", "UID=USERNAME;PWD=****;Port=5480;ReadOnly=0;SQLBitOneZero=0;LegacySQLTables=0;NumericAsChar=0;ShowSystemTables=0;LoginTimeout=0;QueryTimeout=0;DateFormat=1;SecurityLevel=preferredUnSecured;CaCertFile="";Initial Catalog=CONSUMERDB_USERNAME")
  </code></pre>