How to download a file from internet explorer using VBA
<p>I am trying to download an excel workbook from Internet Explorer 11 and when I click on the link, this pop up message appears:</p>

<p><img src="https://i.stack.imgur.com/LOP5O.png" alt="enter image description here"></p>

<p>I've tried to use sendkeys "%s" and it didn't work. I can't use the code to download a file from the internet without using IE because the URL is an intranet site from my company.</p>

<pre><code>Sub Site()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.application")
    With IE
        .Visible = True
        .Navigate "http://asint010/IntegradorProfit/Pages/Relatorios/FluxoSolicitacao.aspx"

        While .Busy Or .ReadyState &lt;&gt; 4
            DoEvents
        Wend

        .document.All("ctl00_ContentPlaceHolder1_btnexportar").Click
        While .Busy Or .ReadyState &lt;&gt; 4
            DoEvents
        Wend

       'here I don't know what to do

    End With
End Sub
</code></pre>