Dear,
I have file which auto opens two others files & links are updated, but now files are auto opened, but links are not updated, and they dont get closed, and remain open, following is vba, it worked earlier, but now not working, kindly explain, where is the problem
Sub Autoupdate_Irhistoryfile()
Dim x As Workbook
Dim y As Workbook
Application.ScreenUpdating = False
Application.AskToUpdateLinks = False
Application.DisplayAlerts = False
Set y = Workbooks.Open("C:\Users\Sethi\Google Drive\HARINDER FILES\IR CALL HISTORY FILE [Conflict 1].xlsx")
Set x = Workbooks.Open("C:\Users\Sethi\Google Drive\HARINDER FILES\copy IR.xlsb")
x.UpdateLink Name:="C:\Users\Sethi\Google Drive\HARINDER FILES\IR CALL HISTORY FILE [Conflict 1].xlsx", _
Type:=xlExcelLinks
Application.AskToUpdateLinks = True
y.Close True
x.Close False
End Sub
Bookmarks