This workbook contains links to other data sources-Excel vba code

Question-How to Disable alert box  This workbook contains links to other data sources Excel       vba code

worning altert-1




Worning Alert-2



Answer Solution-' Disaple Update link alert prompt box

Try below code:-


Application.AskToUpdateLinks = False
Application.DisplayAlerts = False


Try below code-

 Workbooks.Open Filename:=FullFileName, UpdateLinks:=0

Try below code-

Application.ScreenUpdating = False