PDA

View Full Version : WRITE FORMULA TO WORKBOOKS HAVE PASSWORD (EXCEL 2007)



abduhsuryadi
06-15-2012, 02:12 AM
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...