Order of Operations

[mlopes1]

Is there a way to assure that an external data range is refreshed before any of the OnOpen events are performed.

I even tried manually refreshing in the on Open, and then calling the macros:

Private Sub Workbook_Open()
workbooks(1).RefreshAll
macro1 'call the macros
End Sub

But even this performs the macro operations, THEN refreshes, thereby making the macro useless.


Thanks as always,

Mark

 

[mlopes1]

I figured this out and thought I would share in case anyone runs across this.

Turning the external queries property to not "Background Refresh" forces the refreshing to be 100% completed before proceeding to the next line of code.

Simple, but it solved everything for me.