Setting beginarrow head style type in excel using VbScript

[edTech]

Good Morning,
I am writing a script in VbScript that interacts with excel and I am trying to set the hiLoLines property to create the BeginArrowHeadStyle, but I am unsuccessful. Noted below I have place my code of what I have so far and this is within a graph. Please help.


objReadXL.ActiveChart.SeriesCollection(2).Format.line.visible = false
objReadXL.ActiveChart.SeriesCollection(2).MarkerStyle = 8
objReadXL.ActiveChart.SeriesCollection(2).MarkerSize = 7
objReadXL.ActiveChart.SeriesCollection(2).MarkerBackgroundColor = RGB(0, 0, 255)


objReadXL.ActiveChart.ChartGroups(1).HasHiLoLines = True

objReadXL.ActiveChart.ChartGroups(1).HasHiLoLines.line.BeginArrowHeadStyle = 6 'Code Fails here

 

[edTech]

Good Morning,
I am writing a script in VbScript that interacts with excel and I am trying to set the hiLoLines property to create the BeginArrowHeadStyle, but I am unsuccessful. Noted below I have place my code of what I have so far and this is within a graph. Please help.


objReadXL.ActiveChart.SeriesCollection(2).Format.line.visible = false
objReadXL.ActiveChart.SeriesCollection(2).MarkerStyle = 8
objReadXL.ActiveChart.SeriesCollection(2).MarkerSize = 7
objReadXL.ActiveChart.SeriesCollection(2).MarkerBackgroundColor = RGB(0, 0, 255)


objReadXL.ActiveChart.ChartGroups(1).HasHiLoLines = True

objReadXL.ActiveChart.ChartGroups(1).HasHiLoLines.line.BeginArrowHeadStyle = 6 'Code Fails here

I have figured out the code as objReadXL.ActiveChart.ChartGroups(1).HiLoLines.Format.Line.BeginArrowheadStyle = 6

thank you ...