Hello!
I need to copy data from Excel (Column A, Rows are dynamic) to SAP and use it as variable.
How can I replace fixed variable e.g. "10S1.21.02.40.01" with dynamic and make sure all active rows in Column A will be used in SAP (data need to be extracted)?
I need to copy data from Excel (Column A, Rows are dynamic) to SAP and use it as variable.
How can I replace fixed variable e.g. "10S1.21.02.40.01" with dynamic and make sure all active rows in Column A will be used in SAP (data need to be extracted)?
VBA Code:
session.findById("wnd[0]").resizeWorkingPane 133,39,false
session.findById("wnd[0]/usr/cntlIMAGE_CONTAINER/shellcont/shell/shellcont[0]/shell").selectedNode = "F00053"
session.findById("wnd[0]/usr/cntlIMAGE_CONTAINER/shellcont/shell/shellcont[0]/shell").doubleClickNode "F00053"
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").text = [B]"10S1.21.02.40.01"[/B]
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").setFocus
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").caretPosition = 16
session.findById("wnd[0]/tbar[1]/btn[7]").press
session.findById("wnd[0]/tbar[1]/btn[7]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").text = [B]"20S1.20.66.08.01"[/B]
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").setFocus
session.findById("wnd[0]/usr/ctxt*PRPS-POSID").caretPosition = 16
session.findById("wnd[0]/tbar[1]/btn[7]").press
session.findById("wnd[0]/tbar[1]/btn[7]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press
session.findById("wnd[0]/tbar[0]/btn[3]").press