in reply to Problem with Excel and Win32::OLE

Furthermore, I think you need to pass an actual perl false value, not the string 'False', which is a true value in perl. I.e.: 
    ShowSeriesName => 0, # e.g.

[download]

Replies are listed 'Best First'.
Re: Re: Problem with Excel and Win32::OLE
by bmann (Priest) on Apr 29, 2004 at 20:52 UTC
    I was going to post the same thing - until I tested it. When you pass 'false' to the excel object, it treats it as a False value.

    Quick test: 

    use strict;
use warnings;
use Win32::OLE;

my $excel = Win32::OLE->CreateObject('Excel.Application');
$excel->{Visible} = 1;
sleep 5;
$excel->{Visible} = 'False';
sleep 5;
$excel->{Visible} = 1;
print "press enter...";
<STDIN>;

    [download]

    Excel will appear, then disappear for 5 seconds, then reappear.

[reply]
[d/l]

In Section Seekers of Perl Wisdom