Is there any work around in excel VBA to ensure the refresh is Completed through any prompt?

Question

I have a macro to open, refresh the connection and close the workbook. But i am not sure if the refresh is done fully / Properly every time before it closes the file.

Is there any work around in excel VBA to ensure the refresh is Completed through any prompt ?

Please help

Thank You

question from:https://stackoverflow.com/questions/65847760/is-there-any-work-around-in-excel-vba-to-ensure-the-refresh-is-completed-through

Answer 1

Waitting for answers