Make my vba wait?

[Emma Hope]

Hi all,

I have a VBA query which refreshes a workbook and then saves it, then it
changes a particular cell value and then saves it somewhere else.

Unfortunately, the first save hasn't finished before it changes the
particular cell value, so the first save is incorrect.

How can i make the vba understand i want it to wait until the previous line
of code has finished before starting the next bit?

Thanks
Emma

 

[Joel]

Try this

'refresh query
DoEvents

 

[paul.robinson]

Hi
Put in

DoEvents

after the saves. Handy if you have anything updating the screen (e.g
charts or cell values) within code.
regards
Paul

 

[Emma Hope]

this works fine after the save but not with the refresh.....