Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel version

by poj (Abbot)
on Mar 20, 2020 at 15:59 UTC ( [id://11114528]=note: print w/replies, xml ) Need Help??


in reply to Does Win32::OLE::Const->Load('Microsoft Excel'); depends upon Excel version

If you run this code
use strict; use Win32::OLE::Const; Win32::OLE::Const->EnumTypeLibs(\&mylib);; sub mylib { return unless $_[1] =~ /Excel/; print join " ",$_[1],$_[4],"\n"; }

you should get a result like this (14.0 is 2010 , it would probably be 15.0 for 2013)

Microsoft Excel 14.0 Object Library C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
try using the full version name you have in the load eg ->Load('Microsoft Excel 14.0 Object Library');
poj

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2024-04-19 09:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found