Forum Discussion

sanjay0288's avatar
sanjay0288
Frequent Contributor
9 years ago

Why excel show group method not working

Hi,   Why the  method ObjWorkbookNew.Sheets("Sheet1").Outline.ShowLevels RowLevels:=8, ColumnLevels:=8 throws an error in testcomplete. Where as the same method in conventional vbscript is fetching ...
HKosova's avatar
HKosova
SmartBear Alumni (Retired)
9 years ago

I guess it should be:

ObjWorkbookNew.Sheets("Sheet1").Outline.ShowLevels 8, 8

Regular VBScript doesn't support VBA's ParamName:=ParamValue syntax. Excel uses VBA - Visual Basic for Applications - which is different from VBScript.