Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help with Excel OLE automation
Message
From
17/11/1998 11:38:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Need help with Excel OLE automation
Miscellaneous
Thread ID:
00158297
Message ID:
00158297
Views:
51
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
Map
View

Click here to load this message in the networking platform