Hello Monks,

I am running Vista, IE8, IIS7 and am developing a Perl script including HTML and JavaScript. My script opens an existing Excel spreadsheet to read, write, process and display in browser on localhost. From command line my Perl script runs perfectly, but when run in browser on local host I get "Win32::OLE(0.1709) error 0x80070005". Relevant script is:

#!/perl/bin/perl -w
use Win32::OLE qw(in with);
$Win32::OLE::Warn = 3;    # die on errors...
$Excel = Win32::OLE->GetActiveObject('Excel.Application')
    || Win32::OLE->new('Excel.Application', 'Quit');
$Book = $Excel->Workbooks->Open("c:/scripts/RBLCopy.xls");
$xlImport = $Book->Worksheets("Import");
$xlImport->Activate();
$Excel->{'Visible'} = 1;
my $cell= $xlImport->Cells(1,1)->{Value};
[download]

Error occurs at line:

$Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OL
+E->new('Excel.Application', 'Quit');
[download]

I have searched the Monastery, many other sites, and am still waiting to here from Microsoft. I haven't found anything that works. What am I missing or doing wrong?

Please help me!

david