Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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

by poj (Abbot)
on Dec 11, 2017 at 18:53 UTC ( [id://1205299]=note: print w/replies, xml ) Need Help??


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

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

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

      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
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?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1205299]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2024-04-24 00:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found