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


" wrote:

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

On Jun 11, 12:15 pm, Emma Hope
wrote:
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