Re: How do I change the activesheet of an already-open excel spreadsheet using perl?

I figured it out.

my $excel = Win32::OLE->GetActiveObject('Excel.Application')||die "cou
+ldnt get active one";
    $excel -> Windows("SummarySheet.xls") -> Activate;
    my $workbook = $excel    -> Workbooks("EtfSummarySheet.xls");
    $workbook->Activate;
    my $sheet    = $workbook -> Sheets(2);
    $sheet -> Cells(1,1) -> {Value} = "This works great now.";
[download]

Comment on Re: How do I change the activesheet of an already-open excel spreadsheet using perl? Download Code