Here is how I open a password protected execl file:
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Open(MyPath + MyFile, EmptyParam, EmptyParam,
EmptyParam, MyPassword, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, LCID));