title: ADODB RecordSet to string variable VBA
body: <p>Quick question about ADODB recordset. I want to extract a query result from a recordset and set it to a string variable:</p>
  
  <pre><code>query = "SELECT Value1 FROM Table"
  RS = New ADODB.Recordset
  RS.Open(query,Conn)
  </code></pre>
  
  <p>The query is always going to return 3 values. I want take to assign these three values to a variable. RS.GetString returns the query results tab delimited, but I want to be able to iterate through this set and assign each row result to its own variable. Any ideas? Thanks in advance!</p>