title: Import Data in Excel from a table created by a script in a WebPage
body: <p>I am trying to create a macro that automatically connect to a web page and import in excel the data from a table. My problem is that Excel Query tool does not recognize the table, I think because it's create by a script in the page, and so I cannot use the standard way.
  For now, I am using this method:</p>
  
  <ol>
  <li>Copy the data into the clipboard</li>
  <li>Run a vba macro than gets the data from the clipboard and imports it in Excel</li>
  </ol>
  
  <p>However, I have more than 20 web pages to import every time and I would like a "standalone" macro which, given the url of the page, can import the data in excel.</p>
  
  <p>The webpage I am interested in is:
  <a href="http://www.investing.com/indices/us-30-historical-data" rel="nofollow">http://www.investing.com/indices/us-30-historical-data</a>
  I am using excel 2010 </p>
  
  <p>Can anyone help me?</p>