General information
Category:
Coding, syntax & commands
>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...
Previous
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