VBA Open file and allow auto-refresh upon opening to complete

Tardisgx · May 9, 2019

I know how to open a document. I want the VBA to allow the refresh upon opening to complete before saving and closing the workbook.

Code:

Workbooks.Open Filename:="Folder Location"

Tardisgx · May 9, 2019

Strange there is no specific difference; vba overides the document's refresh on opening setting anyway

Code:

Workbooks.Open Filename:="File Location"
    ActiveWorkbook.RefreshAll
    DoEvents
    MsgBox "Complete"