Excel Automation problems

Jan79

Hi,

i searched the Forum, but i wasn't able to find a post to my problem.
I am using the method "Macro it and transfer it to C/AL", but not evry action is logged in the macro.

My specific example: I want to recolor a Series (make it invisible) in a Diagram. The Macro only records the Selection but not the change of color.

The selection code is:

Series := Chart.SeriesCollection(1);
Series.Select;

Now i need to fill the Series.Format with a ChartFormat-Object, which needs to have a FillFormat, this requires a ColorFormat which holds the RGB-Value.

ColorFormat.RGB('vbBlue');
FillFormat.BackColor(ColorFormat);
ChartFormat := ChartFormat.Fill(FillFormat);
//ChartFormat.Fill(FillFormat.BackColor(ColorFormat));
//Series.Format := ChartFormat;

Compiling it results in an error (You have to use a maximum of 0 parameters...), in this line, Cursor standing in front of FillFormat:

ChartFormat := ChartFormat.Fill(FillFormat);

Runtime-Errors occur on this block, telling that there aren't instances of the automation server.

Anyone an idea, how to solve this or knows a good resource on the web?


Thanks in advance
~jan