GUI script in transaction EPRODCUST via Excel VBA

[daniel_mccollum]

I am attempting to script transaction EPRODCUST for test data setup. The data entry recording works flawlessly, so thats nice. IE:

Session.findById("wnd[0]/usr/cntlCC_PARAM_LIST/shellcont/shell").modifyCell 1, "VALUE", DATEFROM

This will correctly place my test data into the cell of the referenced MDT.

My issue arises when I "press" the get key button in the toolbar, then attempt to read the created key out of the grid for later reference.

The recording has an unfamiliar syntax, & Google isn't super useful in helping interpret where I'm going wrong.

Session.findById("wnd[0]/usr/cntlCC_PARAM_LIST/shellcont/shell").Cell 6, "VALUE"

How do I read the contents of this cell into a variable?

I've tried TESTVAR = Session.findById("wnd[0]/usr/cntlCC_PARAM_LIST/shellcont/shell").Cell 6, "VALUE" & it fails syntax check.

Apparently I know just enough to get myself into trouble...

Im more familiar with the syntax:

Session.findById("wnd[2]/usr/tblSAPLSZA6T_CONTROL2/txtADTEL-REMARK[6,0]").Text

where I declare the cell reference completely & use ".text" to read its contents.

cheers.

[daniel_mccollum · Accepted solution]

As per the screen reader tool in http://service.sap.com/sap/support/notes/1441550

I've determined it is a SAPGUI.GridView object with GetCellValue as a function.

it can be queried with this syntax

TESTVAR = Session.findById("wnd[0]/usr/cntlCC_PARAM_LIST/shellcont/shell").GetCellValue(6, "VALUE")