General information
Category:
Coding, syntax & commands
Title:
Need help with Excel OLE automation
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
Next
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