Windows Perl Scripting Forums » News

WIN32::OLE Excel Workbook fails to open intermittently

(1 post)
  • Started 5 years ago by

No tags yet.


  1. Anonymous

    Hello All,
    I am using the following to open an excel workbook and access a sheet.

    my $BucketizedFile = "C:\\temp\\Bucketized.xls";
    $BucketizedOutputFile = $Excel->Workbooks->Open($BucketizedFile);
    my $BucketizedKPI2Sheet = $BucketizedOutputFile->Worksheets("Sheet2");
    $BucketizedKPI2Sheet->{Name}="KPI2";
    $BucketizedKPI2Sheet->Activate();

    I get the following error:
    Can't call method "Worksheets" on an undefined value at Bucketizer_Worksheets_Issue.pl line 347.
    It seems that it was unable to open the Excel sheet successfully.
    I only see this on one particular PC. Why this inconsistency in behavior.
    Any ideas what might be cauing this?
    Appreciate your help.

    Thanks

    Posted 5 years ago #

RSS feed for this topic

Reply

You must log in to post.