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.
Bookmarks