title: VBA Macro to pull data from secure website to excel
body: <p>I have code to pull general data from a website into excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I dont understand how to pass the parameters in. Also, when I run this I only get a dialog box with an "X" and nothing else...
  An edit:
  I am pulling from SAP SuccessFactors. I can get the macro to pull a pdf, associated with a URL, but it wont grab an ad hoc excel report. If anyone has any ideas that would be great! I have pasted my code below:</p>
  
  <pre><code>Dim driver As New Selenium.WebDriver
  Public Sub DownloadFile()
      driver.Start "Chrome"
      driver.Get "https://performancemanager4.successfactors.com/login company=Arrow&amp;username=A79123"
      driver.Wait 20000
      driver.Get "https://performancemanager4.successfactors.com/acme?fbacme_n=analytics&amp;bplte_company=Arrow&amp;_s.crb=EAYY%2bFNmT7%2b%2b8%2fbKt4IEV6RmGRM%3d"
      driver.Wait 1000
      driver.Get "https://performancemanager4.successfactors.com/acme?_s.crb=EAYY%252bFNmT7%252b%252b8%252fbKt4IEV6RmGRM%253d#focus"
      driver.Wait 1000
      driver.Get "file:///C:/Users/a79123/Downloads/report_Hires_by_Job_Family_Sarah_07a6559d-98a8-436d-b686-5abd2a2c631d.pdf"
  End Sub
  </code></pre>