title: Dynamically filling a dropdown box in a web page using an Excel sheet with VBA
body: <p>I have an Excel sheet say A that contains a list from A1 to A75 that has to be dynamically replace the value in a webpage that contains a drop down list.</p>
  
  <p>For each and every replacement value it needs to pull the report from the web page and save that to an Excel sheet B.</p>
  
  <p>All of this function has to happen by clicking a form control button in Excel.</p>
  
  <p>Please suggest &amp; post the code if any.</p>
  
  <hr>
  
  <p>I'm new to VBA and Excel; I’ve been instructed to get the values of currencies across the world with other currencies. This has to be done 365 days.</p>
  
  <p>Although I’ve suggested to try with Macro in order to pull the data from webpage to excel, but after viewing the site i came to know that each and every currency has to be selected from the dropdown list and need to export those currencies to an excel file.</p>
  
  <p>This becomes a hectic issue, so i thought of a solution and come up with an idea (I'm not sure whether this gonna work or not) and posted here to seek assistance for this issue.</p>
  
  <p>//
  Further assistance to the question, Excel file contains more than 75 currencies and those currencies need to be selected with the System date and need to select the Currency code starting from "AED" to "ZWD", for each entry need to export the file to excel. There is an option available for that in that webpage.
  //</p>
  
  <p>Hope this clarifies your requirement, for further assistance please let me know !</p>
  
  <p>Best Regards,Pravin</p>