I have code that opens an excel sheet that always tells me the file
has links and do I want to update the file. The answer will always
be "No" for my application.
I already disabled the alerts but I still get the questions:
"This workbook contains links to other data sources"
"-To update all linked information, click Yes."
"-To keep the exiting information, click No."
I have coded:
Application.DisplayAlerts = False
Application.Workbooks.Open (CurrentDirectory & "\" & FileName)
What am I missing?