Don,


The syntax for ApplyCustomType method is:

expression.ApplyCustomType(ChartType, TypeName)

See more in Excel VBA Help (from Excel, hit ALT+F11, F1)


>If the excel code to create a chart is
>

> ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line - Column"
>

>how would you write this in foxcode?
>
>The following 4 lines will work OK.
>

>xlColumnClustered = 51
>xlBuiltIn = 21
>oExcel.Charts.add
>oExcel.ActiveChart.ChartType = xlColumnClustered
>

>
>But when I try to make it a custom chart it fails. I have tried all of the following variations without success.
>

>oExcel.ActiveChart.ApplyCustomType.ChartType(xlBuiltIn).TypeName = "Line - Column"
>oExcel.ActiveChart.ApplyCustomType.ChartType(xlBuiltIn,"Line - Column")
>oExcel.ActiveChart.ChartType(xlBuiltIn,"Line - Column")
>oExcel.ActiveChart.ChartType = xlBuiltIn
>oExcel.ActiveChart.ChartType = "Line - Column"
>oExcel.ActiveChart.ChartType(xlBuiltIn) = "Line - Column"
>

>
>Also, didn't we used to have a section on UT for OFFICE automation?
>
>Thanks for any help.