Sorry, the subject itself is the explanation. :-)
...
use Win32::OLE::Variant;
...
...
$sheet->PageSetup->{Zoom} = Variant(VT_BOOL, 0);
...
-- Petr Smejkal
-- European Data Administrator
-- Tesco / EuroIT / Business Systems
-- Tesco HO Letnany, Veselska 636, 190 00 Praha 9
-- +420 - 2 - 840 14 639
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Petr Smejkal
> Sent: Thursday, January 04, 2001 3:23 PM
> To: Perl-Win32-Users
> Subject: OLE Variant Variable
>
>
> Hi,
>
> I'm trying to set MSExcel ActiveSheet.PageSetup.Zoom property to False.
> According to documentation Zoom can be a number between 10 and
> 500 or False.
> Setting Zoom property to 0 (as so as another number outside the range) in
> VBA reaises an error.
>
> Unfortunately Pert has no boolean type, so how can I set it to
> False but not
> 0???
>
> # $sheet ....... ActiveSheet
> $sheet->PageSetup->{Zoom} = 0; # has no effect
>
> -- Petr Smejkal
> -- European Data Administrator
> -- Tesco / EuroIT / Business Systems
> -- Tesco HO Letnany, Veselska 636, 190 00 Praha 9
> -- +420 - 2 - 840 14 639
>
> _______________________________________________
> Perl-Win32-Users mailing list
> [EMAIL PROTECTED]
> http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
