Master workbook linked to multiple password protected files

I have seen this posted before but I can't seem to find a solution that works so maybe I'm doing it wrong. I have a master workbook that links to 17 password protected files and summarizes the data. When I open the master, I'm prompted to enter a password for every linked file. The password is the same for all. I tried a couple of different VBA codes but I still have the issue upon opening. I want the links to be updated but I don't want to have to enter a password 17 times!

Here's the one I thought had the most promise but isn't working. Can anybody help?

Private Sub Workbook_Open()
Dim PWord As String
PWord = "password"
SendKeys PWord & "{Enter}"
ActiveWorkbook.UpdateLink Name:="filename.xlsm", Type:=xlExcelLinks
End Sub

Possibly using...

Please Login or Register  to view this content.

That didn't work but it's possible I'm putting it in the wrong place....I'm adding it to modules under thisworkbook but I have two now that I've tried. Are they potentially conflicting?

Try putting this in the Thisworkbook code module, save and close the file and then reopen it. It should bring up a file dialog where you can pick all the files to update.

Please Login or Register  to view this content.

Sorry for this next questions as I'm very new to VB...
Am I supposed to replace V with my master file name?
....And vfile with each of the 17 feeder files?
At which instance?

No, the code should be in the master file. When you open that file, the subroutine runs, and it will display a built in user interface for selecting the files you want to process. Once you make the selections, it will open each selected file, update the links and then close the file, repeating the process for every file you selected.