Getting error while extracting data from SAP

Note that your findById method should return an object. Also try the below code as fix to your code:

session.findById("wnd[0]/tbar[1]/btn[8]").press On Error Resume next myText = "x" err.clear myText = session.findById("wnd[1]/tbar[0]").Text if err.number <> 0 then myText = "" on error goto 0 If myText = "No data exists for chosen selection" Then GoTo TroubleShootInterCompany End If