Hi Friends,

I had a perl script to convert .txt files to .xls after doing some calculations and filtering. It was working fine in Excel 2010.Recently I had Excel 2016 installed and from then its throwing me an error as follows "No type library matching "Microsoft Excel" found at C:\GMIO Transaction Audit Process\Perl Script\NewScript.pl line 13". Here is the script till line 13. Request your help regarding this

 
#!/usr/bin/perl
# These are the modules the program utilizes.
# Strict is a module which compiles the code to avoid syntax issues.
# List::Util was utilized for part of the random selection .
# The POSIX module was utilized also in the random selection #function
+ 
# Win32::OLE is for utilizing Excel within Perl.

use strict;
use File::Find;
use POSIX qw(ceil);
use List::Util 'shuffle';
use Win32::OLE::Const "Microsoft Excel";
[download]