title: Excel VBA Scrape Web Page
body: <p>I'm trying to scrape the following webpage </p>
  
  <p><a href="http://www.bseindia.com/markets/equity/EQReports/StockPrcHistori.aspx?flag=0&amp;expandable=7" rel="nofollow">http://www.bseindia.com/markets/equity/EQReports/StockPrcHistori.aspx?flag=0&amp;expandable=7</a></p>
  
  <p>The <em>search box (which says Enter Scrip Name / Code / ID)</em>, is where I am having difficulty,
  I am able to set the value of the box to the scrip ID <strong>500222</strong> by using the following code,</p>
  
  <p><code>IE.Document.All.Item("ctl00$ContentPlaceHolder1$GetQuote1_smartSearch").innerText = "500222"</code></p>
  
  <p>However if you try entering the value <strong>500222</strong> in the search box manually you will get a drop down box which will be the name of the corresponding scrip. I can't however make it work via VBA. Any help would be great.</p>