in reply to Re^9: Reading Excel
in thread Reading Excel

Thankyou.But if iam running the same script OLE exception fro m "Microsoft Excel"; Unable to get the Open property of the Workbook class.Win32::OLE (0.1709)error 0x800a03ec in METHOD/PROPERTYGET "Open" at C:\Perl\Read.pl

Replies are listed 'Best First'.
Re^11: Reading Excel
by huck (Prior) on Jan 30, 2017 at 10:39 UTC

    i got that message when i had only 

    my $Excel=Win32::OLE->GetActiveObject('Excel.Application');

    [download]
    instead of 
     
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
|| Win32::OLE->new('Excel.Application', 'Quit');

    [download]
    Do you reaize what the difference is?

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom