Re^7: Excel Const - No type library matching error message

On the failing system what does this give

#!perl
use strict;
use Win32::OLE;
print "Win32::OLE : $Win32::OLE::VERSION \n";
my $Excel = Win32::OLE->new('Excel.Application', 'Quit');
print "Excel ".$Excel->{Version};
[download]

poj

Comment on Re^7: Excel Const - No type library matching error message Download Code

Replies are listed 'Best First'.
Re^8: Excel Const - No type library matching error message by merrymonk (Hermit) on Dec 11, 2017 at 18:26 UTC
On the failing system the result of your Perl was Win32::OLE : 0.1709 Excel 15.0 Oddly I am told the same was obtained where the Const was successful. On my system, which is OK, the output was Win32::OLE : 0.1712 Excel 14.0	[reply]
Re^9: Excel Const - No type library matching error message by poj (Abbot) on Dec 11, 2017 at 18:53 UTC
Try updating the 0.1709 (April 17th 2008) to the latest version 0.1712 (May 14th 2014). Do you have a mixture of 32 bit and 64 bit versions ? poj	[reply]
Re^10: Excel Const - No type library matching error message by merrymonk (Hermit) on Dec 11, 2017 at 22:20 UTC
Can you give me some clues about how to update the OLE version? For example does Excel have to be reloaded. Excuse my ignorance but up to now I have simply used the version of Excel that is there with the Perl that is supplied by a third party. I have to explain this to my user.	[reply]
Re^11: Excel Const - No type library matching error message by poj (Abbot) on Dec 12, 2017 at 18:31 UTC
Re^10: Excel Const - No type library matching error message by merrymonk (Hermit) on Dec 11, 2017 at 22:22 UTC
I also should have asked - when you ask about 32 and 64 bit versions - do you mean just Excel?	[reply]


Just another Perl shrine
	PerlMonks