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.