Simple code that refreshes link to another excel file with Password

[piflechien73]

Hello,

I have a code that opens other files in order to update links. There is one password also.
See below:

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 :-)