in reply to Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel version

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