Issues With File Download through IE11 Automation

I am attempting to download and open an excel file from the intranet using a macro to avoid having to pull the data manually on a daily basis. As of now, the data is uploaded and stored, daily, on the intranet and then pulled manually to be used in various reports. I am attempting to build a macro in an existing report that will pull the data automatically and have come across a few issues. I have figured out (for the most part) how to navigate through the IE interface to get to the file I need extracted. Upon executing the logic to "Save" the file, the IE download window pops up (IE11 gold/white bar at bottom of page) and after selecting "Open", the "running security scan" message appears. I have used Wait/Sleep events to wait for the file to open, but for whatever reason, the file never opens. Until I mouse click in excel, which by that point, the macro has already errored out. I have been looking extensively for any fixes for this and am coming up empty handed. Any help or advice would be greatly appreciated! I am a relatively new user of VBA so be gentle. Below is the logic I have so far:

Please Login or Register  to view this content.

(OP add code tags …)

Hi ckulback,

This sounds like a job for Power Query to me. You can install it as an Add-In to 2010 excel, from Microsoft.
https://www.microsoft.com/en-us/down...9-02650663144d

and then import your data using it.

https://support.office.com/en-us/art...8-b68e9e616f5a or
https://www.youtube.com/watch?v=LACjRvxl_2w