Re: Hopefully simple Excel question...

Have you tried,

$myActiveChart->HasAxis($the_constant_value_I_looked_up_already, $ditt
+o) = 0;#?guess
[download]

You might try to look up 'Excel' in the search and, if possible, post your Perl version of your code.

Celebrate Intellectual Diversity

Comment on Re: Hopefully simple Excel question... Download Code

Replies are listed 'Best First'.
Re^2: Hopefully simple Excel question... by Anonymous Monk on Dec 15, 2005 at 20:58 UTC
Grandfather. Sorry about that. I was (chose one of the 2 F words) around and since I didn't see the post there after doing a refresh I thought maybe I didn't create it. Apologize for any inconvenience. Oh by the way I had tried that code and it didn't work.	[reply]
Re^2: Hopefully simple Excel question... by Anonymous Monk on Mar 06, 2009 at 12:34 UTC
The correct syntax to set the Excel chart's HasAxis-Property in Perl looks like this: `$myActiveChart->SetProperty('HasAxis',[2,1],0);` The second parameter is an Array that contains the parameters that shall be passed to the property-method. My example is equivalent to this VBA-Code: `myActiveChart.HasAxis(xlValue,xlPrimary)=False` Tested and works!	[reply] [d/l] [select]