|laziness, impatience, and hubris|
Re: Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel versionby syphilis (Bishop)
|on Mar 19, 2020 at 23:39 UTC||Need Help??|
The example in the Win32::OLE documentation seems to be trying to load Excel as:
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:
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.