Hi;
I am trying to convert an excel macro for inserting a chart into vfp code and am having a problem with the two macro lines below (the second line starts with 'PlotBy'):
ActiveChart.SetSourceData Source:=Sheets("cheqsale").Range("AB4:AB8"), _
PlotBy:=xlColumns
I have tried (and numerous other possibilities):
oExcel.ActiveChart.SetSourceData Source:=Sheets("cheqsale").Range("AB4:AB8"), _PlotBy:=xlColumns
I am using an excel.h file for constants.
Any ideas would be appreciated.
John
John Campbell