Excel VBA with GUIScripting - For each element

[#1]

Hi All,

I am not sure if i am at the right platform to ask this question.

1) I will like to know if there is any place that i can read up on the respective property or function of the syntax.

For example, session.findById("wnd[0]").maximize, I extracted this from the output of the Script recording, I will like to know, what other function is there, or findById is the only function?

2) I will also like to check, if it is possible for me to use VBA to loop through all the element in the SAPGUI and return a value.

For example,

Dim X as object

For each X in Session.

If X.Text = "New Entries" then

....

End If

....

My objective is to find if whether the element exist on the screen or it is still loading.

Regards

David

[Former Member]

I managed to find the SAP GUI Scripting help file and sapfewse.ocx.

but I really keen to learn how to loop through the element/object in SAP

[daniel_mccollum]

https://answers.sap.com/questions/13039407/how-to-upload-sap-table-from-excel-64x-with-vba.html

Stefan has a nicely clean example here.