Password Protected Excel Files Open while Display set to 0

pankaj_it09 has asked for the wisdom of the Perl Monks concerning the following question:

The below code displays the password protected excel files even though the display is set to 0.

use Win32::OLE;

$Excel = Win32::OLE->new('Excel.Application') or die "oops\n";

$Excel->Workbooks->Open({FileName => "D:\\Perl\\bin\\search tool\\test
+.xls"}) || die ("$!\n");

$Excel->{Visible} = 0;

$Excel->Quit;
[download]

Comment on Password Protected Excel Files Open while Display set to 0 Download Code

Replies are listed 'Best First'.
Re: Password Protected Excel Files Open while Display set to 0 by Anonymous Monk on Jan 23, 2009 at 07:07 UTC
check for errors	[reply]
Re^2: Password Protected Excel Files Open while Display set to 0 by pankaj_it09 (Scribe) on Jan 23, 2009 at 07:19 UTC
According to the above code the excel files should not get open as display is set to 0.	[reply]
Re^3: Password Protected Excel Files Open while Display set to 0 by Anonymous Monk on Jan 23, 2009 at 07:54 UTC
But you're not checking for errors `Win32::OLE->LastError()` [download]	[reply] [d/l]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re^3: Password Protected Excel Files Open while Display set to 0 by weismat (Friar) on Jan 23, 2009 at 07:37 UTC
What Excel version are using? As this code is based on the deprecated OLE interface, there is a risk that MS has not implemented it properly in newer version.	[reply]
Re^4: Password Protected Excel Files Open while Display set to 0 by pankaj_it09 (Scribe) on Jan 23, 2009 at 11:02 UTC