Windows Perl Scripting Forums » News

WIN32::OLE Excel Workbook fails to open intermittently

(1 post)
  • Started 7 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");

    I get the following error:
    Can't call method "Worksheets" on an undefined value at 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.


    Posted 7 years ago #

RSS feed for this topic


You must log in to post.