Hello,
I have a code that opens other files in order to update links. There is one password also.
See below:
Code:Sub OpenTheTemplate()
Dim filename As String
Workbooks.Open (ThisWorkbook.Path & "" & Range("x16").Value & ".xlsx"), Password:="BT2023", writerespassword:="BT2023"
End Sub
I was wondering if there is one existing that just "refreshes" links instead of opening the files each time
Many thanks for help :-)