Skip to Content
avatar image
Former Member

How to copy value from grey sap Field to excel VBA?


I need to copy a certain value from a field in SAP that is grey.

The field is impossible to edit or to copy by CTRL+C, only CTRL+Y works.

I want to make VBA to copy this field to excel cell but my goal is to use it in IF function. IF this field has this value then do something etc.

I have this field "adress"

 Info.Range("G8").Value = sessieon.findByID("wnd[0]/usr/tabsTABSPR1/tabpSP09/ssubTABFRA1:SAPLMGMM:2000/subSUB3:SAPLMGD1:2302/ctxtMARA-EKWSL").Text

"Info" is the name of my sheet. If i use the begining of the code above but make it show text/values from field that is white(active/changable) it appears in my excel cell G8. However it doesnt work on the GREY fields.

Could anyone provide feedback?

Please redirect me to correct tag if this one is wrong again.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers