Macro to open and close another workbook that's password protected

[cruyff73]

Hi,

I have a number of workbooks (15) for staff that contain stats - these are password protected to the individual.

I have a mastercopy which is linked to these so that I can pull the stats together for me to analyse the team performance. Currently I have to input all the passwords in manually to update the mastercopy.

So...I'm trying to set a VBA so that when I open my workbook it will automatically open and close the individual sheets, entering the password (without prompting) so that it all updates seamlessly. I don't need to update the individual workbooks in any way, just need to open for to allow for the pulling of information. The individual sheets will more than likely be open at the same time so I would probably get the "in use" alert which I would want to ignore and allow read only.

For info the an example file path is "M:\CCB\FRK\FR1\[Paul Dyson.xlsx]"

Any help greatly appreciated

Thanks

 

[cruyff73]

(Couldn't find an edit post option)....I should add that I don't actually need the individual workbooks to open due to the links being in place I just need to be able to pull the info.