Excel - Linked Workbook Passwords

[Maver1ck666]

I have a workbook that collates the information from 12 other workbooks but each workbook has a different password. Is there a way I can replace the formula in each cell (a grid of 105 cells) so that a vba function would call each workbook, open it with the required password automatically and update the cell in the laster workbook with the accumulative value?

i.e.

Cell B4 has =Sum(Workbook1!B4,Workbook2!B4,Workbook3!B4,Workbook4!B4...)
Cell C4 has =Sum(Workbook1!C4,Workbook2!C4,Workbook3!C4,Workbook4!C4...)

I hope this makes sense. If you need anything else, please let me know.

Kind regards,
Mav

[westconn1]

Is there a way I can replace the formula in each cell (a grid of 105 cells) so that a vba function would call each workbook, open it with the required password automatically

as you are referring to the workbooks multiple times, you could just open them all, then update the cells with formula then close all, rather than having to open all / many for each cell containing formula