从SAP提取.currentCellRow字段到Excel [英] Extracting .currentCellRow fields from SAP to Excel

问题描述

我已经将vba与SAP一起使用了一段时间，但从未遇到过此特定问题.

I have been using vba with SAP for a while now and have never run into this particular issue.

通常，在SAP中记录脚本时，我单击一个字段，然后剩下一些以.setfocus结尾的代码字符串.我将其替换为.text，以提取该单元格中的数据.

Usually, when script recording in SAP, I click on a field and am left with some string of code with a .setfocus as the end. I replace this with .text in order to extract the data in that cell.

我遇到了一个以.currentCellRow =#结尾的菜单，因此如果我更改它，它会失去位置并且不知道我在说什么领域.

I have run into a menu that ends in .currentCellRow= # and thus if I change it, it loses its position and has no idea what field I am talking about.

有什么方法可以调整以从这些字段中提取数据吗?

Is there any way that I can adjust this to pull data from these fields?

这是我编写的字段的示例

Here is an example of a field I scripted

session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell").currentCellRow = 4

推荐答案

.getcellvalue(4，列名")

.getcellvalue(4,"name of column")

另请参见: https: //answers.sap.com/questions/300278/reading-grid-cells-sap-gui-scripting-vbs.html

关于， 脚本人

这篇关于从SAP提取.currentCellRow字段到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！