title: dsn-less connection for oracle through excel vba
body: <p>how do i create a dsn-less connection for an oracle db through excel vba.</p>
  
  <p>here's how i'm doing it in access vba (i have functions for the variables in the string, GetOracleDriver and TNSName because each machine can have their own) but in excel i don't see the oracle driver when i tried doing it by hand.</p>
  
  <pre><code>Dim NewConnect As String
  
  NewConnect = "ODBC;DRIVER={" &amp; GetOracleDriver &amp; "};SERVER=" &amp; TNSName &amp; ".mycompany.com;UID=myuid;PWD=mypwd;DBQ=" &amp; TNSName &amp; ".mycompany.com;"
  </code></pre>
  
  <p>thank you</p>