topic Re: SAP GUI Scripting using Visual Basic in Excel 2010 in Application Development and Automation Discussions

SAP GUI Scripting using Visual Basic in Excel 2010

Former Member — Mon, 26 Aug 2013 10:06:00 GMT

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

Re: SAP GUI Scripting using Visual Basic in Excel 2010

Former Member — Mon, 26 Aug 2013 10:47:29 GMT

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"

Re: SAP GUI Scripting using Visual Basic in Excel 2010

Former Member — Mon, 18 Jul 2016 17:48:49 GMT

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

Re: SAP GUI Scripting using Visual Basic in Excel 2010

former_member583234 — Sun, 07 Jul 2019 07:39:37 GMT

Hi,

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