Hi,

If I understand you correctly, following should help :
YourObject.Workbooks.Open Filename:=YourFile, password:="ABCD"

HTH
Carim