Forum Discussion

sanjay0288's avatar
sanjay0288
Frequent Contributor
10 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?

  • HKosova's avatar
    HKosova
    Icon for Alumni rankAlumni
    10 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.