Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a SparkLines with VB script

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

1 Reply
Not applicable
Author

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