E
Eric
Does anyone have any suggestions on why the following macro cannot update the
file links?
They can be updated before, without changing anything, when I run the macro
again, it executes open, save and close without updating all the links and
perform all the updated calculation. If I open each file manually, then the
links can be updated and perform updated calculation.
Does anyone have any suggestion on what wrong excel is?
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
file links?
They can be updated before, without changing anything, when I run the macro
again, it executes open, save and close without updating all the links and
perform all the updated calculation. If I open each file manually, then the
links can be updated and perform updated calculation.
Does anyone have any suggestion on what wrong excel is?
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