Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP to Excel Chart problem...
Message
De
09/10/1998 15:08:58
 
 
À
09/10/1998 02:04:26
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00144375
Message ID:
00145523
Vues:
28
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform