title: Download automation with VBA and IE
body: <p>I am trying to automate a process of downloading file from a website. At the moment I am able to open a link that runs a javascript which produces an output file, here's my code:</p>
  
  <pre><code>Sub WebDataExtraction()
  
  Dim URL As String
  Dim IeApp As Object
  
  URL = "http://si3.bcentral.cl/Siete/secure/cuadros/DescargarExcel.aspx?DropDownListFrequency=&amp;DrDwnCalculo=NONE&amp;codCuadro=UF_IVP_DIARIO"
  
  Set IeApp = CreateObject("InternetExplorer.Application")
  
  IeApp.Navigate URL
  
  End Sub
  </code></pre>
  
  <p>When I run the sub the IE View Downloads window pops out. To download the file I am trying to follow <a href="http://www.siddharthrout.com/2011/10/23/vbavb-netvb6click-opensavecancel-button-on-ie-download-window/" rel="nofollow noreferrer">this approach</a>, however while I am using the attached code I am unable to find a child window.</p>
  
  <p>Can somebody advise me how to proceed from here? Or maybe any suggestion how to approach this problem differently?</p>