Closing Files and Reopening them in VBA
 

Hi, I have a blackbox Excel Sheet with a bunch of macros that I close
and open through another excel sheet because the blackbox Excel sheet
needs to 'refresh' every once in a while. This I do rather simply using
ActiveWorkbook.Close False method. The problem I'm having is that it
doesn't seem to close 'fully' or get refreshed properly. This may be
because the next line in my macro opens it up again as it's supposed
to, although I did try using an Application.Wait for 60 seconds between
the two. Also, because the process is so quick, visually the screen
doesn't actually show the file closing down. Is there a way to ensure
that the Activeworkbook.Close fully closes the file or are there any
other commands? Thanks in advance.
Naresh

Closing Files and Reopening them in VBA
 

You may check to see if you have screenupdating turned off. If you do, it
won't show the workbook closing and reopening.

"VBAQuest" wrote:

Hi, I have a blackbox Excel Sheet with a bunch of macros that I close
and open through another excel sheet because the blackbox Excel sheet
needs to 'refresh' every once in a while. This I do rather simply using
ActiveWorkbook.Close False method. The problem I'm having is that it
doesn't seem to close 'fully' or get refreshed properly. This may be
because the next line in my macro opens it up again as it's supposed
to, although I did try using an Application.Wait for 60 seconds between
the two. Also, because the process is so quick, visually the screen
doesn't actually show the file closing down. Is there a way to ensure
that the Activeworkbook.Close fully closes the file or are there any
other commands? Thanks in advance.
Naresh