title: VBA, ADO.Connection and query parameters
body: <p>I have excel VBA script:<br></p>
  
  <pre><code>Set cоnn = CreateObject("ADODB.Connection")
  conn.Open "report"
  Set rs = conn.Execute("select * from table" ) 
  </code></pre>
  
  <p>Script work fine, but i want to add parameter to it. For example " where (parentid = <em>myparam</em>)", where <em>myparam</em> setted outside query string. How can i do it?</p>
  
  <p>Of course i can modify query string, but i think it not very wise.</p>