How do i refer a cell in SAP code.

[Prasoonj]

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 !!

 

[vletm]

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.

Copy & Paste Codes from sheet2 to Macro module

Hi all, Greeting, Need your kind help for completing my project. Requirement:- I have a customized macro codes in the excel sheet named "sheet2 " from cell A2 to A250 . i need to copy this code in Macro Module named "Format" and save .. so that i can run a macro with my customized code. Need a...

chandoo.org

 

[dan_l]

don't forget to test that sap script in quality