Hello,

Your answer is right in your question :)

my $Book = Excel->Workbooks->Open(
{  FileName => 'test.xls',
   Password => 'abc123' } ) or die "Cant open excel file: $!";
[download]

All attributes you pasted for Workbooks.Open are valid for opening excel file with Win32::OLE. You just use them as hash keys and values.

In 318680 node I posted 2 links that might be useful.

Hope that helps.
-sheep