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

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

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