lepetitalbert has asked for the wisdom of the Perl Monks concerning the following question:
dear Monks,
After a couple of hours reading stuff about 'bless' due to a
Can't call method "Workbooks" on unblessed reference
I still don't understand.
the error come from the last line :
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
I have no idea about what I have to bless : $book, $Excel or $excel_template.
Any hint is welcome
Have a nice day
"There is only one good, namely knowledge, and only one evil, namely ignorance." Socrates
Back to
Seekers of Perl Wisdom