I have a problem with VBA EXCEL. help me please.

The problem is: I want to write formula to another CLOSED WORKBOOKS that has password like this code:

ActiveCell.Formula="='D:\myFolder\[myExcel.xlsx]Sheet1'!$A$1"

how can I supply a password automatically FROM VBA when I excute that CODE? cause I have more than 20 workbooks.

Thanks before...