This is a bit aggravating.
I'm using Win32::OLE to read and write a number of spreadsheets
from a perl/tk script. When the user clicks a button, I go through
and write some cells:
$Win32::OLE::Warn = 3; # die on errors...
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
|| Win32::OLE->new('Excel.Application', 'Quit');
my $Book = $Excel->Workbooks->Open(
"$dest_dir/$entry_widget_test_name/VOPU.xls"
);
my $Sheet = $Book->Worksheets(1);
# write some cells
$Sheet->Cells($row,$col)->{'Value'} = $value;
$Book->Close;
I end up doing this a couple of times per operation.
The annoying bit is that I get a popup asking the user
"Do you want to save changes" yes/no.
Is there a way to shut this popup question off?
_______________________________________________
Boston-pm mailing list
[email protected]
http://mail.pm.org/mailman/listinfo/boston-pm
