title: Retreive Displayed text field in SAP through macro with Excel
body: <p>I tried to run the SAP script recording to gather a text that is displayed for several item numbers automatically. While I was checking it this is the code I got :</p>
  
  <pre><code>If Not IsObject(application) Then
     Set SapGuiAuto  = GetObject("SAPGUI")
     Set application = SapGuiAuto.GetScriptingEngine
  End If
  If Not IsObject(connection) Then
     Set connection = application.Children(0)
  End If
  If Not IsObject(session) Then
     Set session    = connection.Children(0)
  End If
  If IsObject(WScript) Then
     WScript.ConnectObject session,     "on"
     WScript.ConnectObject application, "on"
  End If
  session.findById("wnd[0]").maximize
  session.findById("wnd[0]/tbar[0]/okcd").text = "CS03"
  session.findById("wnd[0]").sendVKey 0
  session.findById("wnd[0]/usr/ctxtRC29N-STLAN").setFocus
  session.findById("wnd[0]/usr/ctxtRC29N-STLAN").caretPosition = 0
  session.findById("wnd[0]").sendVKey 4
  session.findById("wnd[1]/usr/lbl[1,10]").setFocus
  session.findById("wnd[1]/usr/lbl[1,10]").caretPosition = 0
  session.findById("wnd[1]/tbar[0]/btn[0]").press
  session.findById("wnd[0]/usr/ctxtRC29N-MATNR").text = "508546"
  session.findById("wnd[0]/usr/ctxtRC29N-WERKS").text = "1000"
  session.findById("wnd[0]/usr/ctxtRC29N-WERKS").setFocus
  session.findById("wnd[0]/tbar[0]/btn[0]").press
  session.findById("wnd[0]/usr/tblSAPLCSDITCALT/ctxtRC29K-STLST[1,15]").setFocus
  session.findById("wnd[0]").sendVKey 2
  session.findById("wnd[0]/tbar[0]/btn[3]").press
  session.findById("wnd[0]/usr/tblSAPLCSDITCALT/ctxtRC29K-STLST[1,15]").setFocus
  session.findById("wnd[0]").sendVKey 2
  session.findById("wnd[0]/usr/tabsTS_ITOV/tabpTCDO").select
  session.findById("wnd[0]/usr/tabsTS_ITOV/tabpTCMA").select
  session.findById("wnd[0]/usr/tabsTS_ITOV/tabpTCMA/ssubSUBPAGE:SAPLCSDI:0152/tblSAPLCSDITCMAT/txtRC29P-KTEXT[3,3]").setFocus
  session.findById("wnd[0]").sendVKey 2
  session.findById("wnd[0]/usr/tabsTS_ITEM/tabpPDAT").select
  session.findById("wnd[0]/tbar[0]/btn[3]").press
  session.findById("wnd[0]/usr/tabsTS_ITOV/tabpTCMA/ssubSUBPAGE:SAPLCSDI:0152/tblSAPLCSDITCMAT/txtRC29P-KTEXT[3,6]").setFocus
  session.findById("wnd[0]").sendVKey 2
  session.findById("wnd[0]/usr/tabsTS_ITEM/tabpPDAT/ssubSUBPAGE:SAPLCSDI:0840/btnRC29P-ICON1").press
  session.findById("wnd[0]/usr/cntlSCMSW_CONTAINER_2102/shellcont/shell").setDocument 1,"e1xydGYxXGFkZWZsYW5nMTAyNVxhbnNpXGFuc2ljcGcxMjUyXHVjM="
  </code></pre>
  
  <p>Obviously, I did not get the required result as I want to retrieve the displayed text and not the text field. Any ideas on how to get that?</p>