Resolving Common Issues for SAP GUI Scripting | SAP Settings and Debugging Tips for SAP Scripts

Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!

When I started my journey with SAP GUI Scripting, there’s a lot of things that seems like common sense now, but I spent a lot of time trying to figure out how to make it work in Excel VBA.

When I'm trying to 1st make it work I have several issues such as keeping getting notification that a script is attempting to access SAP GUI or opening a connection, asking me to allow or deny to save an exported file, and more frustratingly unable to get Excel to run my script because I am not able to find SAP GUI Scripting API.

In this video, I'll share the steps to setup your system environment for SAP GUI Scripting and some tips for debugging your SAP Script if you are just getting started with SAP GUI Scripting and Excel VBA.

Timestamps
00:00 Introduction
00:17 SAP Settings – Enable scripting & avoid "A Script is Attempting to Access SAP GUI" Message
00:44 SAP Settings – Security Settings (Set Default Action to Allow)
01:00 SAP Settings – Selecting Spreadsheet Format for Exports
01:37 Excel Preparations – Enable Developer tab in Ribbon to access Visual Basic Editor
02:08 Excel Preparations – Enable SAP GUI Scripting API under Tools, References
02:48 Debugging Tips – Step Into
03:27 Debugging Tips – Watch Window
04:28 Debugging Tips – Breakpoints
05:20 Thanks for Watching!

#SAPScripting #ExcelSAPAutomation #SAPScriptingwithVBA
#A script is attempting to access SAP GUI
#A script is opening a connection to system
#Compile error: User-defined type not defined

DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.

MY FAVOURITE GEAR

🤝 BE MY FRIEND:

🙎🏻‍♂️ WHO AM I:
I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity.

📧 GET IN TOUCH:

[JoelTing]

I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below:

[womubcj]

thanks a lot! the tips about setting up the GUI and the Developer API were extremly helpful!

[NguyenTrang-cxrd]

Dear Joeh, this is amazing video that I have solved my problem. Please keep going on sharing more useful videos 🥰

[MKEWSH]

Awesome, keep SAP GUI tips and tricks videos coming :)

[stevejohnson]

Another awesome video. Keep them coming.👍

[satyanarayanamurtykodukula]

Hello Joel, That was an awesome video. Keep it up and post some more useful videos.

[JoelTing]

Timestamps
00:17 SAP Settings – Enable scripting & avoid "A Script is Attempting to Access SAP GUI" Message
00:44 SAP Settings – Security Settings (Set Default Action to Allow)
01:00 SAP Settings – Selecting Spreadsheet Format for Exports
01:37 Excel Preparations – Enable Developer tab in Ribbon to access Visual Basic Editor
02:08 Excel Preparations – Enable SAP GUI Scripting API under Tools, References
02:48 Debugging Tips – Step Into
03:27 Debugging Tips – Watch Window
04:28 Debugging Tips – Breakpoints
05:20 Thanks for Watching!

[yogeshloganathan]

Your videos are good reference for me for developing my projects requirements. Thanks a ton👍

[karmaestark]

Hi, muchas gracias por compartir el conocimiento

[minxu]

Hi Joel, appreciated for your contribution. Videos are really helpful.

One question: If one Date field in Script is a specific one, but in reality, it needs to be "Today", how I could adjust the code in script?

[rupalineema]

Thanks This video is really helpful. But while executing a particular transaction type there is no data generated in SAP and then I want to continue with another company code how to do that.

[vishal-gghk]

Hey Joel, Great content !!

I m facing issue that after clicking on script recording I am unable to record anything, I mean editing part in tcode areas not working . Could you please help in this regard ?

[emilblack]

Hi Joel, thank you for all your work.

I'm having an issue though, the moment I have to select a spreadsheet the space for the route and the name of the file comes as a pop-up window outside SAP, also, the only available format I have is Office 2003 XML Format, instead of the Office Open XML Format (XLSX).

[jollestmc]

Hi Joel I really appreciate your helpful videos. I am using the Power Automate VB function and I am encountering a problem that I cant solve, maybe you can help? When I try to add a new employee the script fails at the point of Create Actions. I can see that it creates red brackets around the entire create actions page, those brackets would normally appear against a data input field and it then fails. When I run the script and it falls over, I have tried to record the script from that point however as soon as I click on the record script function in SAP, the brackets around the page disappear. I am at a loss as to how to resolve this.. If you could assist me I would be very grateful.

[sanjeewasamaranayake]

Thanks for this. I have a problem when I run some transactions in SAP that takes say 2-3 minute to complete. For those transactions VB throws a pop up message saying that the interface is not responding. I googled for a solution to disable these messages, but none worked. Also added a wait but that did not help too. Without the ability to avoid these pop ups -automation stop in the middle awaiting for a manual confirmation. script do not complete awaiting intervention.

[VIMAL]

Hi Joel, Your this video was helpful.
Could you help me with this error pop
"the enumerator of the collection cannot find an element with the specified index".
It comes when I try execute this line of code. " Set Session=objconn.children(0)"

[luiscamarena]

Hi Joel,

Is there any problem if the Security Option is not highlight in the SAP options?
I think this is a server/security problem with our company. Need I to be a superuser to proceed with the scripting?

[SimpleExcelVBA]

Very nice video :)
Do You know how to undo "Always Use Selected Format" of spreadsheet?

[gonzaloalvareznavarro]

hi Joel,
One question: how to disable auto open when you export to excel file from SAP?

[_cimbora]

Hi Joel,
i must say very rich content👏👏👏👏

could you please help me how to change the system, as in my organisation recording is allowed in the "Quality system" only, how to use the scripts recorded in the "Quality system" to "Production system".

Thanks