Question Re: SAP GUI SCRIPTING - taking data from excel in Technology Q&A

SAP GUI SCRIPTING - taking data from excel

former_member712998 — Thu, 05 May 2022 07:45:18 GMT

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

Re: SAP GUI SCRIPTING - taking data from excel

Sandra_Rossi — Thu, 05 May 2022 12:21:59 GMT

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)

Re: SAP GUI SCRIPTING - taking data from excel

former_member712998 — Thu, 05 May 2022 13:09:09 GMT

This is my script

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