| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I update an excel file without opening it? | Excel Discussion (Misc queries) | |||
| Suppressing Update Links Warning | Excel Programming | |||
| Update data wihout opening the file? | Excel Programming | |||
| Update data without opening file? | Excel Discussion (Misc queries) | |||
| automatically update links without opening file | Excel Worksheet Functions | |||
Linear Mode
