i try to put it

like this below




Sub Workbook_Open()

Application.DisplayAlerts = False

End Sub


It doesn't work fro what I want it to be.

I wrote vba in Access. Excel in one small part in the code to get refreshing
new data.

I try to set excel workbook itself by

Menu bar : Edit --Links--Startup Prompt
I selected "Don't display the alert and update links"


These didn't work. Hmmmm.... It work in my other workbooks. And these make
me don't know what should I continue to do.












"March" wrote:

I'm not sure that you mean I have to put the code in Excel or Access.



"Rick Rothstein (MVP - VB)" wrote:

I don't know if this will work for what you are doing or not, but try
putting this statement..

Application.DisplayAlerts = False

beforehand and set it back to True afterwards.

Rick


"March" wrote in message
...
Hello All,

I don't know how to write VBA to skip the warning pop-up in Access.

I have one file in Excel. The file is link to Access.

I want to skip the pop-up that says

"Microsoft Excel

This workbook contains links to other data sources

-to update all linked info, click yes

-to keep the existing info, click no"


For the link, I have to keep it updates all time.


I want to make it automated update through the excel file.


Please give me suggestion.


Thank you,


March