in reply to Re^7: Excel Const - No type library matching error message
in thread Excel Const - No type library matching error message

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
  • Comment on Re^8: Excel Const - No type library matching error message

Replies are listed 'Best First'.
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]
      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]

        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]
      I also should have asked - when you ask about 32 and 64 bit versions - do you mean just Excel?
[reply]

In Section Seekers of Perl Wisdom