title: Paste an Excel range in browser using Selenium + VBA
body: <p>I have a scenario where I am trying to copy a range of cells (Single Column) from Excel and paste the range in a textarea tag in Chrome browser, which is identified using ID. I am using Excel VBA and Selenium. </p>
  
  <p>There seems to be no error when copying of the range. However, when I try to paste the range in the textarea using Selenium Keys, I am currently unable to paste the values. As my Excel range can sometimes extend to more than 1000 rows, I am out of option to paste the cells one after the other, as the browser times out. </p>
  
  <p>My html code is something like this.</p>
  
  <p>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=</p>
  
  <pre><code>&lt;div&gt;
      &lt;div&gt;
          &lt;textarea&gt; id = "textarea1"
          &lt;/textarea&gt;
      &lt;/div&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=</p>
  
  <p>I have tried using the below three codes, in vain.</p>
  
  <p>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=</p>
  
  <pre><code>selenium.findElementByID("textarea1").sendkeys (keys.Control &amp; "v")
  selenium.findElementByID("textarea1").sendkeys keys.Control, "v"
  selenium.findElementByID("textarea1").sendkeys (keys.Control +"v")
  </code></pre>
  
  <p>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=</p>
  
  <p>Can someone help me identify the issue here and the workaround.</p>