E
Eric
Does anyone have any suggestions on why the following files cannot be updated?
They can be updated before, without changing anything, when I run the list
again, it just open and close without updating the links and perform all the
updated calculation. I have checked the advance option to perform
automatically calculation on those worksheet.
Does anyone have any suggestion on how to solve this problem?
Thanks in advance for any suggestions
Eric
Sub Temp()
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\File1.xls", UpdateLinks:=3
Workbooks("File1.xls").Close savechanges:=True
Workbooks.Open Filename:="C:\File2.xls", UpdateLinks:=3
Workbooks("File2.xls").Close savechanges:=True
....
Workbooks("Update Files").Close savechanges:=True
End Sub
They can be updated before, without changing anything, when I run the list
again, it just open and close without updating the links and perform all the
updated calculation. I have checked the advance option to perform
automatically calculation on those worksheet.
Does anyone have any suggestion on how to solve this problem?
Thanks in advance for any suggestions
Eric
Sub Temp()
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\File1.xls", UpdateLinks:=3
Workbooks("File1.xls").Close savechanges:=True
Workbooks.Open Filename:="C:\File2.xls", UpdateLinks:=3
Workbooks("File2.xls").Close savechanges:=True
....
Workbooks("Update Files").Close savechanges:=True
End Sub