Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make my vba wait?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make my vba wait?
Try this
'refresh query DoEvents "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make my vba wait?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make my vba wait?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
Make VBA wait for return from external function | Excel Programming | |||
Make onTimer wait until Excel finish database request? | Excel Programming | |||
Help with Wait X Then Go | Excel Programming | |||
Wait less than a second | Excel Programming |