SAPGuiTableTree issue

[shilparach]

Dear all,

I am working on one of the SAP scripts and there is a node in the screen that changes according to the input data.

Code:

'SAPGuiSession("Session").SAPGuiWindow("Termination of Plan Participat").SAPGuiTree("TableTreeControl").Set "#4","401K","ON"

where '#4' always changes.

Could anyone please guide me how '#4' could be parameterized.

Thanks, Shilpa

[Saket]

Try This

Code:

'Add a column in your datatable say - 'Num'
'take the value from datatable
NumValue = Datatable("Num","your sheet")
'Set the value
SAPGuiSession("Session").SAPGuiWindow("Termination of Plan Participat").SAPGuiTree("TableTreeControl").Set "#" & NumValue,"401K","ON"

does this help?

[shilparach]

Hi Saket,

The input data here is the personnel number and based on the personnel number, the 401 k changes its location. The input data is not the one from the localsheet.

Thanks,
SR