| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wait time between Saving and other activity
I have code that closes and saves a large workbook. I then display a message
box, but I can't seem to do anything with it for a while. I'm thinking it's because the large workbook isn't really completely closed yet. Is there some code that I can use to check that it's closed? -- HTH, Barb Reinhardt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wait time between Saving and other activity
Just a thought, couldn't you add some code right before the msgbox
routine that counts the number of visible windows, or checks if the file is still open, before displaying? --JP On Aug 13, 3:27*pm, Barb Reinhardt wrote: I have code that closes and saves a large workbook. *I then display a message box, but I can't seem to do anything with it for a while. *I'm thinking it's because the large workbook isn't really completely closed yet. * Is there some code that I can use to check that it's closed? -- HTH, Barb Reinhardt |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wait time between Saving and other activity
Take a look at doevents. It might help with your issue...
http://msdn.microsoft.com/en-us/library/aa262728.aspx -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: I have code that closes and saves a large workbook. I then display a message box, but I can't seem to do anything with it for a while. I'm thinking it's because the large workbook isn't really completely closed yet. Is there some code that I can use to check that it's closed? -- HTH, Barb Reinhardt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alert if the travel activity is after the work activity | Excel Worksheet Functions | |||
| daily activity time log | Excel Discussion (Misc queries) | |||
| Saving files. Please wait. | Excel Programming | |||
| date time stamp excel activity log entry? | Excel Programming | |||
| Wait time variable | Excel Programming | |||
Linear Mode
