VBA Opening WB's - how to eliminate all "...can't update links..." warnings

[franklin_m]

I'm running a bit of code to open all the *.xlsx files in the same folder as the *.xlsm file. But I keep getting the window that says:

We can't update some of the links in your workbook right now.
You can continue without updating their values, or edit the links you think are wrong.​

Here's the snippet of the code that's opening the files...

MyPath = ActiveWorkbook.Path & "\"
MyFiles = Dir(MyPath & "*.xlsx")
    
Do While MyFiles <> ""
       Workbooks.Open MyPath & MyFiles
       Application.AskToUpdateLinks = False

       ' Other code here

Loop

One thing that may or may not make a difference, is that in the 'Other code part, it calls routines. One adds a worksheet to the open *.xlsx file, and another puts some formulas in that new worksheet.

Thanks for the help.

 

[NdNoviceHlp]

Maybe...

Application.DisplayAlerts = False

HTH. Dave

 

[franklin_m]

Worked like a champ!
Thanks!