perlquestion
lepetitalbert
<p>dear Monks, </p>
<p>After a couple of hours reading stuff about 'bless' due to a </p>
<code>
Can't call method "Workbooks" on unblessed reference
</code>
<p>I still don't understand.</p>
<p>the error come from the last line :</p>
<code>
my $excel_template = $file_sys_path . $invoice_page_name;
my $Excel = Win32::OLE->GetActiveObject('Excel.Application') or Win32::OLE->new('Excel.Application', 'Quit') or die "Could not start excel";
$Excel->{'Visible'} = 0;
$Excel->{DisplayAlerts} = 0;
my $book = $Excel->Workbooks->Open( $excel_template ) or die ; # open Excel file
</code>
<p>I have no idea about what I have to bless : $book, $Excel or $excel_template.</p>
<P>Any hint is welcome</p>
<p>Have a nice day</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-502458">
"There is only one good, namely knowledge, and only one evil, namely ignorance." Socrates
</div></div>