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

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.

Comment on Re^10: Excel Const - No type library matching error message

Replies are listed 'Best First'.
Re^11: Excel Const - No type library matching error message by poj (Abbot) on Dec 12, 2017 at 18:31 UTC
0.1709 is the version of the Win32::OLE perl module. What version of perl do you have ?. Type `perl -v` on the command line and you should see something like this c:\temp>perl -v This is perl 5, version 16, subversion 1 (v5.16.1) built for MSWin32-x64-multi-thread (with 1 registered patch, see perl -V for more detail) Copyright 1987-2012, Larry Wall Binary build 1601 296175 provided by ActiveState http://www.ActiveState.com Built Aug 30 2012 18:41:50 I don't think I can help you much more because it looks like the failing system is with Excel 15 (Office 2013) and I only have the same as your working system Excel 14 (Office 2010). poj	[reply] [d/l]

Replies are listed 'Best First'.

Re^11: Excel Const - No type library matching error message
by poj (Abbot) on Dec 12, 2017 at 18:31 UTC

0.1709 is the version of the Win32::OLE perl module. What version of perl do you have ?. Type perl -v on the command line and you should see something like this

c:\temp>perl -v

This is perl 5, version 16, subversion 1 (v5.16.1) built for MSWin32-x64-multi-thread
(with 1 registered patch, see perl -V for more detail)

Copyright 1987-2012, Larry Wall

Binary build 1601 296175 provided by ActiveState http://www.ActiveState.com
Built Aug 30 2012 18:41:50

I don't think I can help you much more because it looks like the failing system is with Excel 15 (Office 2013) and I only have the same as your working system Excel 14 (Office 2010).

[reply]
[d/l]