I have a macro that opens another excel file to copy some data from, when the other file opens a messagebox appears that says "This workbook contains one or more links that cannot be updated" and there are two options "Continue" or "Edit Links" is there any way for the code to be changed so that it continues without this message box appearing?
Regards
Regards
Code:
CurrentFileName = ActiveWorkbook.Name
Title = "Select File"
FileName = Application.GetOpenFilename(Finfo, FilterIndex, Title)
If FileName = False Then
MsgBox "No file was selected."
Exit Sub
Else
MsgBox "You Have Selected " & FileName
End If
Workbooks.Open FileName, ReadOnly:=1