Adding a SparkLines with VB script

[#1]

Dear Team,

i am making a sparklines with a VBScript in a Excel. Below are the line which i used for same after the Excel export in Excel

xlApp.ActiveSheet.Range("$T$3:$T$10").SparklineGroups.Add Type:=xlSparkLine, SourceData:="K2:L10"

above line giving me Syntax Error

i also have try below mention also

xlApp.ActiveSheet.Range("$T$3:$T$10").SparklineGroups.Add XlSparkType.xlSparkLine,xlApp.ActiveSheet.Range("K3:L10")

this is also not working.

Kindly help.

Regards,

JKV

[#2]

did any one have any idea how to use sparkline in vbscript