Suppressing the UPDATE while opening a file
 

Hi all,

I have a macro in a file which calls to open other files. As the other files
open, they ask to update the data.
I want these files to open without asking me to update, but they should
automatically update.
Is there a command that I can add as a line in my macro?

Thanks,
Berj

Suppressing the UPDATE while opening a file
 

Application.DisplayAlerts = False

"Berj" wrote:

Hi all,

I have a macro in a file which calls to open other files. As the other files
open, they ask to update the data.
I want these files to open without asking me to update, but they should
automatically update.
Is there a command that I can add as a line in my macro?

Thanks,
Berj