hbwin testole excel issue

[ankitkuchhal2000]

there is not any availability for Missing value option in excel ole
i want to add worksheet in between 2 sheets
command is oworkbook:worksheets:Add() but it fails when add using before and after command
oworkbook:workSheets:Add(After: oworkbook:worksheets[oworkbook:workSheets:Count]);

[APerricone]

Are you sure of this syntax, I think you must write

oworkbook:workSheets:Add(,oworkbook:worksheets[oworkbook:workSheets:Count])

see the comma after the parenthesis, it mean the second parameter, that is after: https://docs.microsoft.com/en-us/office/vba/api/excel.sheets.add