Skip to Content
0

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

Jun 02, 2017 at 07:22 PM

93

avatar image
Former Member

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.

sap | excel | vba
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers