cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hello,

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.

Accepted Solutions (0)

Answers (0)