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