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

Also, I should have said then when the following is run on the failing system I get the output underneath (just part of this is listed.

use strict;
my ($key);
print "\nD Version test - Perl version is <$]>\n";
print "\n\nusing Win32::OLE::Const\n\n";
use Win32::OLE;
use Win32::OLE::Const;
my $Excel = Win32::OLE->new('Excel.Application', 'Quit');
my $xlcon = Win32::OLE::Const->Load($Excel);
foreach $key (sort {$a cmp $b} keys %$xlcon) {
    print "$key value $xlcon->{$key}\n";
}

[download]

D Version test - Perl version is <5.012002>


using Win32::OLE::Const

_xlDialogChartSourceData value 541
_xlDialogPhonetic value 538
rgbAliceBlue value 16775408
rgbAntiqueWhite value 14150650
rgbAqua value 16776960
rgbAquamarine value 13959039
rgbAzure value 16777200
rgbBeige value 14480885
rgbBisque value 12903679
rgbBlack value 0
rgbBlanchedAlmond value 13495295
rgbBlue value 16711680

Replies are listed 'Best First'.
Re^7: Excel Const - No type library matching error message
by poj (Abbot) on Dec 10, 2017 at 13:53 UTC

    On the failing system what does this give

    #!perl
use strict;
use Win32::OLE;
print "Win32::OLE : $Win32::OLE::VERSION \n";
my $Excel = Win32::OLE->new('Excel.Application', 'Quit');
print "Excel ".$Excel->{Version};

    [download]
    poj
[reply]
[d/l]
      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
[reply]

        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]

In Section Seekers of Perl Wisdom