RefreshAll not quick enough
Help!
I have the following lines of code:
'-----------------------------------------------
ThisWorkbook.RefreshAll
If Range("Input_Date_Flash") <= Range("Access_LatestDate") Then
'blah blah
End If
'-----------------------------------------------
When the workbook refreshes, the range("Access_LatestDate") which
contains a query into an Access file refreshes after the next line of
code executes!
Do I need to add in a line below the line ThisWorkbook.RefreshAll, or
am I just going about this in the wrong way?
Any help greatly appreciated,
Jason.
|