Re: Re: Re: Re: Re: Re: Problem with Excel and Win32::OLE

D'oh,
and I searched hours for a solution...

But the code:

$Chart -> Axes(xlCategory) -> Select;
$Excel->Selection->TickLabels({Font => {Size => 8}});
[download]

Still won't function, it should resize the Font of the xlCategory in a chart to 8, but it still remains at the default size of 10... I tried several versions, but still won't function...

Thanks for help...

Comment on Re: Re: Re: Re: Re: Re: Problem with Excel and Win32::OLE Download Code

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Re: Re: Problem with Excel and Win32::OLE by bmann (Priest) on May 10, 2004 at 18:04 UTC
TickLabels is not a function, so don't use it like one. `$Excel->Selection->TickLabels({Font => {Size => 8}});` Should be (Untested!) `$Excel->Selection->TickLabels->Font->{Size} = 8;` This stuff is fundamental to using OLE from perl. You need to read the Win32::OLE docs as well as Excel's help file to help you understand how to translate from VB to perl.	[reply] [d/l] [select]