I want to switch this off the auto calculation in Excel, I have tried the
following but it has no effect.
use Win32::OLE::Const 'Microsoft Excel';
$xl = Win32::OLE::Const->Load("Microsoft Excel");
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
|| Win32::OLE->new('Excel.Application', 'Quit');
$Excel->XlCalculation($xl->{xlCalculationManual});
any ideas ?
Kevin.
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
