Information générale
Catégorie:
Codage, syntaxe et commandes
>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
xlcolumnclusted is a constant that is equal to 51.
You can find the value of these constants by starting Excel
and then using Alt-F11 then F2 (object browser). From there
you can search for the value of constants. Do that or include
the excel constants in a header file...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement