Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing and reopening the same file | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions | |||
Userform retain data after closing and reopening | Excel Programming | |||
My comments reformat after closing and reopening. | Excel Discussion (Misc queries) | |||
macro statement will not run a second time without closing and reopening | Excel Programming |