Excel Chart

[Static]

O has already been set up as a excel.application
I keep getting errors with this...
I created it in the macro of Excel but need it to work in VB

O.Charts.Add
O.ActiveChart.ChartType = xlLine <-ERROR
O.ActiveChart.SetSourceData Source:=O.Sheets("MarketSmart").Range("F1:G" & MScr), PlotBy:=xlColumns
O.ActiveChart.Location here:=xlLocationAsNewSheet, Name:="MS Chart" <-ERROR
With O.ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "MarketSmart"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Date"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Defects"
End With
O.ActiveChart.HasDataTable = False



HELP!!!!!!

[jp_schwartz]

What´s the error?

When working with Excel, you´ll have to declare all the constants that are involved. Execute the macro step by step and look for the constants and their value. I used to declare all the constants that I need in a module.