in reply to Excel Const - No type library matching error message

What do you get if you run this on both systems

#!perl
use strict;
use Win32::OLE::Const;
Win32::OLE::Const->EnumTypeLibs(\&mylib);;

sub mylib {
  return unless $_[1] =~ /Excel/;
  print join " ",$_[1],$_[4],"\n";
}

[download]
poj

Replies are listed 'Best First'.
Re^2: Excel Const - No type library matching error message
by merrymonk (Hermit) on Dec 06, 2017 at 21:07 UTC
    I got this on my PC
    Microsoft Excel 14.0 Object Library C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
    Microsoft Excel 14.0 Object Library C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE

    Is that the sort of output you are expecting?
    I will get the Perl run on the 2 other systems tomorrow and post here what is obtained.
[reply]
      I now have the results of running the test on two different systems with the same version of Perl.
      On the system where the Const variants failed, nothing was printed out.

      On the system where the Const was successful, the following was written out.

      Microsoft Excel 15.0 Object Library C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
      AdHocReportingExcelClientLib C:\Program Files (x86)\Microsoft Office\Office15\ADDINS\Power View Excel Add-in\AdHocReportingExcelClient.dll
      Microsoft Excel 15.0 Object Library C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
      AdHocReportingExcelClientLib C:\Program Files (x86)\Microsoft Office\Office15\ADDINS\Power View Excel Add-in\AdHocReportingExcelClient.dll

      From this I gather that there is something missing from the failing system and that this may be something like the dll shown.
      What is the simplest way to correct this? Is it as simple as copying the dll?
[reply]

        Does the failing system have Excel installed ?

        poj
[reply]

In Section Seekers of Perl Wisdom