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 me results?

1 Reply

  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)

    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.