S
sot
Basically I've tried to create a macro that opens up all the files in one of
my folders and refreshes the querys in them which bring though new data from
Access. But Excel is determined to try rushing through the steps and
save/close the files before the refresh/calc has finished! Is there a way
around this. See below for current Macro.
Workbooks.Open Filename:= _
"S:\Planning\DP\AW2010 Planning\B+M Tierings\Latest View\AW10
Tiering.xls"
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWindow.Close
my folders and refreshes the querys in them which bring though new data from
Access. But Excel is determined to try rushing through the steps and
save/close the files before the refresh/calc has finished! Is there a way
around this. See below for current Macro.
Workbooks.Open Filename:= _
"S:\Planning\DP\AW2010 Planning\B+M Tierings\Latest View\AW10
Tiering.xls"
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWindow.Close