Excel is waiting for another application to complete an OLE action

Hello everyone. I am currently writing code that will go into an intranet site we have and export data and save the files to a specific location. The code does this for 66 different data pulls. During the loop, it seems like if the intranet site takes a little too long, excel will throw the error "Excel is waiting for another application to complete an OLE action" If i click the "OK" option on this message, the loop will continue. Sometimes, i will get that message 2-10 times during the whole process. Does anyone have any suggestions on how to handle this message through VBA?

easy way to not get that message and let it run/wait is using :

Please Login or Register  to view this content.

this way excel will click OK for you without pop it up for you.

To realy solve your problem you would need to code in that after each single pull you terminate the intranet conection with excel.

Thanks for the reply. With the above solution (DisplayAlerts), will that affect the dialog boxes that pop up during the export and save functions that i have in my code?