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...
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...