General information
Category:
Coding, syntax & commands
Thanks for your previous answer but one confusion.
Example:
These are the macro statements in Excel
Sheets("Chart1").Select
ActiveChart.Walls.Select
Selection.Interior.ColorIndex = xlNone
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 17
End With
Selection.Interior.ColorIndex = xlNone
End Sub
These are what I think should be the Foxpro statements but the last 2 do not work. They give an error.
o_xlsheet.Chartobjects(1).chart.walls.Interior.ColorIndex = -4142 &&good line
o_xlsheet.Chartobjects(1).chart.SeriesCollection(1).border.ColorIndex = 17
o_xlsheet.Chartobjects(1).chart.SeriesCollection(1).Interior.ColorIndex = -4142
Can you tell me what I am doing wrong.
TIA
Robert
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only