Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to Excel Chart problem...
Message
From
09/10/1998 15:08:58
 
 
To
09/10/1998 02:04:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00144375
Message ID:
00145523
Views:
26
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
Map
View

Click here to load this message in the networking platform