10-04-2018 11:15 AM
I'm new with script recording. I made a recording of the generation of cost centers report.
session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").Text = "/nS_ALR_87013611"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/ctxt$1KOKRE").Text = "ZSMO"
session.findById("wnd[0]/usr/txt$1GJAHR").Text = "2018"
session.findById("wnd[0]/usr/ctxt$1PERIV").Text = "9"
session.findById("wnd[0]/usr/ctxt$1PERIB").Text = "9"
session.findById("wnd[0]/usr/ctxt$1VERP").Text = "0"
session.findById("wnd[0]/usr/ctxt$1KOSET").Text = "$ZSMO"
session.findById("wnd[0]/usr/ctxt$1KOSET").SetFocus
session.findById("wnd[0]/usr/ctxt$1KOSET").caretPosition = 5
session.findById("wnd[0]").sendVKey 8
session.findById("wnd[0]/shellcont/shell/shellcont[2]/shell").selectedNode = "000003"
session.findById("wnd[0]/usr").verticalScrollbar.Position = 25
session.findById("wnd[0]/usr").verticalScrollbar.Position = 26
session.findById("wnd[0]").sendVKey 82
session.findById("wnd[0]/usr/lbl[5,48]").SetFocus
session.findById("wnd[0]/usr/lbl[5,48]").caretPosition = 13
session.findById("wnd[0]").sendVKey 2
session.findById("wnd[1]/usr/lbl[1,1]").caretPosition = 23
session.findById("wnd[1]").sendVKey 2
session.findById("wnd[0]/mbar/menu[0]/menu[3]/menu[2]").Select
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").Select
session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").SetFocus
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[1]/usr/ctxtDY_PATH").SetFocus
session.findById("wnd[1]/usr/ctxtDY_PATH").caretPosition = 25
session.findById("wnd[1]").sendVKey 4
session.findById("wnd[1]/tbar[0]/btn[11]").press
*=>>> session.findById("wnd[1]/usr/ctxtLGRWO-OUT_FILE").Text = "C:\Users\" & ID & "\Desktop\PC\" & Name & ".xls"
session.findById("wnd[1]/usr/ctxtLGRWO-OUT_FILE").SetFocus
session.findById("wnd[1]/usr/ctxtLGRWO-OUT_FILE").caretPosition = 42
session.findById("wnd[1]/tbar[0]/btn[0]").press
session.findById("wnd[2]/usr/btnSPOP-VAROPTION2").press
session.findById("wnd[1]/usr/btnSPOP-VAROPTION1").press
*I am struck at this step whereby opening of the "Save As" screen in the scripting. Please guide me thanks.
12-11-2018 6:28 PM
Hi! If you want combine first you need storage the text like "COL1":
COL1 = "Name"
session.findById("wnd[1]/usr/ctxtDY_PATH").text = "C:\Users\JanetTan\Desktop\PC\"
session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = COL1 & ".XLS"
OR directly Replace "JanetTan" by the user name.