RE: [OLE] excel, variants

[Tillman, James]

What does it do when you just pass in 0's and 1's instead of $vtfalse and $vttrue?  I've found that Win32::OLE normally converts my values to the simple variants for me.  If this doesn't work, I'd try using positioned parameters instead of named ones.  You can usually just pass in undef for the params you don't want to send.

 

jpt

-----Original Message-----
From: Hans Scholte [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 4:13 AM
To: Perl-Win32-Users Mailing List
Subject: [OLE] excel, variants

Hi,

 

I'm trying to get the following to work (AutoFormat is a method (MS Excel) that wants variants as input):

my $vtfalse = Variant(VT_BOOL, 0);
my $vttrue = Variant(VT_BOOL, 1);
$sh->Range("A1:Z26")->AutoFormat('Number'    => $vtfalse, 'Font'      => $vtfalse, 'Alignment' => $vtfalse, 'Border'    => $vtfalse, 'Pattern'   => $vtfalse, 'Width'     => $vttrue);

Apparently this doesn't work. When i just do

 

$sh->Range("A1:Z26")->AutoFormat

 

then it works but excel's formatting things i don't want to be formatted!

 

 

Hans