I'm trying to format excel from VBS - I'm grouping several columns and it works fine but I need to collapse the column level. The last line (in bold) was recorded using the macro recorder. My question is: how do I translate this so it will run in VBS (how do I collapse the outline in VBS)?
Set myExcel = CreateObject("Excel.Application")
myExcel.visible = TRUE
Set mySheet = myWorkbook.sheets(1)
ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=1