Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help with Excel OLE automation
Message
De
17/11/1998 11:38:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Need help with Excel OLE automation
Divers
Thread ID:
00158297
Message ID:
00158297
Vues:
52
I need help converting the following named arguments to positional arguments. I have tried many unsuccessful guesses. Also, what the heck do you do with values such as 'xlColumnClustered' that Fox chokes on?

PRE
goexcel.Range("A1:D3").Select
goexcel.Charts.Add
goexcel.ActiveChart.ChartType = xlColumnClustered
goexcel.ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:D3"), PlotBy:= xlRows
goexcel.ActiveChart.Location Where:=xlLocationAsNewSheet
With goexcel.ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Test chart"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Month"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Dollars"
EndWith
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform