title: How to scrape data from a terminal and paste into Excel?
body: <p>I'm trying to collect information from the terminal using column C as the source, but I don't know how to write the result in the following manner into Excel.</p>
  <p><a href="https://i.stack.imgur.com/NmRoZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NmRoZ.png" alt="What is needed" /></a></p>
  <p>This is the code I have so far:</p>
  <pre class="lang-vb prettyprint-override"><code>Dim cell As Range
  Dim Rs As String
  
  For Each cell In sheet1.Range(&quot;C:C&quot;)
      Sess.putstring cell.Value, 1, 10, 3    'Query Value
      Sess.SendKeys &quot;&lt;ENTER&gt;&quot;
      Rs = Sess.screen.GetString(1, 11, 3)   'Result
  Next cell
  </code></pre>