duluter
02-05-2009, 09:22 AM
Hi.
I have a macro that opens up a bunch of workbooks one at a time, grabs data, and closes them. These workbooks have links to other workbooks and when I open them from my macro, Excel pops up a message asking me if I want to update the links. I don't want to update the links, and I don't want to see this message because it prevents the macro from running without user interaction.
I have the following code to attempt to prevent these messages from appearing. This code seems to work fine when I run the macro in Excel 2007. But the messages still pop up when I run the code on Excel 2003. My users are using 2003, so I need this to work in that environment.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Can anyone tell me why the above code is not preventing Excel from popping this message up? What is the code I should be using?
Thanks very much.
Duluter
I have a macro that opens up a bunch of workbooks one at a time, grabs data, and closes them. These workbooks have links to other workbooks and when I open them from my macro, Excel pops up a message asking me if I want to update the links. I don't want to update the links, and I don't want to see this message because it prevents the macro from running without user interaction.
I have the following code to attempt to prevent these messages from appearing. This code seems to work fine when I run the macro in Excel 2007. But the messages still pop up when I run the code on Excel 2003. My users are using 2003, so I need this to work in that environment.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Can anyone tell me why the above code is not preventing Excel from popping this message up? What is the code I should be using?
Thanks very much.
Duluter