Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why can't Win32::OLE talk to Excel2003 under Win2003?

Tags:

excel

perl

ole

I have a Web-based Perl Win32::OLE script that uses Excel on the server side. It has been working happily for years on a Win2000 server running Excel2000. We recently upgraded to Win2003/Excel2003 and I now get the following error from the script:

 Win32::OLE(0.1709) error 0x80070005: "Access is denied" at create_worksheet_lib.plx line 639
eval {...} called at create_worksheet_lib.plx line 639

line 639 is:

$Excel = Win32::OLE->new('Excel.Application', sub {$_[0]->Quit;}) or die "Oops, cannot start Excel";

It appears that Perl no longer has access to Excel. Any Windows gurus out there that might be able to help trouble shoot this?

like image 497
dorianw Avatar asked Jan 12 '09 22:01

dorianw


1 Answers

Seems like the same wicked problem described in another post, however, no solution found...

Maybe troubleshooting with Procmon will reveal where the problem lies (see http://support.microsoft.com/kb/286198).

like image 101
Dirk Vollmar Avatar answered Nov 05 '22 16:11

Dirk Vollmar