SAP GUI SCRIPTING - taking data from excel

[Sandra_Rossi]

Hello,

I recorded automate to extend materials in SAP. Values are taken from my template from the excel(below)

As you can see in below script: 1 line refers to 3 column in above excel and 2 line refers to 4 column.
The problem is I do not want to make it "rigid" I want to make it in different way. When the cell is processed, I would like the script to take the data from the next cell on the right.

session.findById("wnd[0]/usr/tabsTABSPR1/tabpSP04/ssubTABFRA1:SAPLMGMM:2000/subS - Pastebin.com

[Sandra_Rossi]

Please post the code as text instead of image, so that one can easily answer by testing your code.

(also, my company doesn't allow access to pastebin.com, so I can't see your code)

[former_member712998 · Accepted solution]

This is my script

1. session.findById("wnd[0]/usr/tabsTABSPR1/tabpSP04/ssubTABFRA1:SAPLMGMM:2000/subSUB2:SAPLMGD1:2158/ctxtMVKE-VRKME").Text = Cells(10, 3)
2. session.findById("wnd[0]/usr/tabsTABSPR1/tabpSP04/ssubTABFRA1:SAPLMGMM:2000/subSUB4:SAPLMGD1:2159/txtMVKE-AUMNG").Text = Cells(10, 4)