I have this piece of code for generating an excel graph.
Can some one help me in defining the "Range" in a different numerical way?
ex. can i set the range as 1,1:2,2 instead of A1:B2? (This is not working anyway!)
thanks in advance.
Dim $oXL ;2
$oXL = ObjGet($FilePath)
$oXL.Windows(1).Visible = 1
$oXL.Worksheets(1).Activate
$oXL.ActiveSheet.Visible = 1
$oXL.Application.Visible = 1
$oXL.Charts.add()
$oXL.ActiveChart.ChartType =51 ;bar chart= 51
$oXL.ActiveChart.SetSourceData($