Execute VB Code in Background 1

[inf33323]

Hi,

is there any possibility for background VB code execution? This would be helpful in the following situation: I compare values in two different workbooks. In order to read them, I need to open them and they will show up on the screen all the time. I could hide the windows but I wonder if there is a more ellegant solution...

Thanks a lot.

 

[scottrod]

In your code, you can try
Application.ScreenUpdating=False
Application.StatusBar = "Opening File X"

This should allow you to open files in the 'background' without the screen changing. While screen updating is turned off, I like to use the second line to change the status bar, so I can see and tell the user that something is happening, be patient.

Before you end the routine, want the screen to update, or to clear the message on the status bar use:

Application.ScreenUpdating=True
Application.StatusBar = " "