SAP GUI Scripting using Visual Basic in Excel 2010

[Former Member]

Hi Folks,

I have recently started with creation of SAP Test Automation Framework using Visual Basic in Excel 2010.

I have recorded all the objects using SAP GUI Script Recording and Playback option and customizing it using Visual Basic in an excel sheet wherein I have kept my Test Data as well.

I have few doubts and questions, and would be thankful if somebody could help me answer these questions:

1. How would I be able to differentiate between different SAP windows

For example: SAP Login Window and Display Document Window (FB03) both are referenced by

session.findById("wnd[0]")

Would that be possible for me to differentiate between different transaction windows in SAP.

2. After entering Login id and password to the Login Window, I want the same should be reported to an excel, if or not I am able to login to SAP.

Logic:  If the login window exists even after entering login id and password and pressing enter, unsuccessful login attempt should be reported to the excel.

Would that be possible for me to differentiate the windows according to specific buttons or input / read only fields on a particular screen.

Thanks,
Vaibhav Gupta

[Former Member]

Thanks guys. The problem is resolved now.

We can differentiate between different SAP windows using  session.ActiveWindow.Text function.

Example: After entering FB03 in transaction window, we can refer the window using

session.ActiveWindow.Text = "Display Document: Initial Screen"

[Former Member]

Hi Goodd Day,

Can you please de complete code for compare?  I'm trying finish my vba but the window for atacch document doesn't works in fb03

Best Regards

Lucas Santana

[former_member583234]

Hi,

Can I bring the remarks to the Excel sheets while running VBA and scripting