Hi
agnes00,
The example in the Win32::OLE documentation seems to be trying to load Excel as:
$xl = Win32::OLE->new('Excel.Application') or die "oops\n";
You could try that and see if it makes a difference.
Did the test suite pass when you installed Win32::OLE ?
If you installed it via ppm, then you won't have run the test suite.
In that case grab
the Win32::OLE source, unpack it to some location, cd to that location, and run:
perl t/2_variant.t
perl t/3_ole.t
Let us know if they both pass. Please provide a copy'n'paste of the results if there are failures.
(Those 2 test files seem to rely on the loadability of Excel, and are therefore relevant to your issue.)
Other than that, try looking through
the Win32:OLE bug reports and see if there's anything there that helps.
Nothing there stands out to me, though
67609 might perhaps be relevant.
I don't know much about Win32::OLE - I don't have it, nor do I have Excel. And I doubt that Win32::OLE is being actively maintained. (The current version on CPAN is 6 years old.)
There's also a number of modules that have been written for Excel. Perhaps one of them might better suit your purposes - I don't know.
You can see a list of those modules at
https://metacpan.org/search?q=Excel.
Cheers,
Rob