• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i refer a cell in SAP code.

Prasoonj

New Member
Dear All,

This codes (session.findById("wnd[0]/usr/ctxtS_BUKRS-LOW").text = "277") updates a SAP field with the Value "277".
The value 277 is based on the excel Sheet1 Cell = A2 . So how can I refer this cell in the above code to have the value.

Example : If A2 = 299 , then i need a code as "session.findById("wnd[0]/usr/ctxtS_BUKRS-LOW").text = "299"

Thanks in advance !!
 
Prasoonj
You can test something like below - - I cannot test!
Note: use Your correct used name with Sheets instead Your_Used_Sheet_Name!
session.findById("wnd[0]/usr/ctxtS_BUKRS-LOW").text = Sheets(Your_Used_Sheet_Name).Range("A2")
Late note: Of course, there needs to do something else too ... like ... to use that code as it should use ... other way that You have used to use it.

Please, do not duplicate Your thread! Below is Your original.
 
Last edited:
Back
Top