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

Рет қаралды 46,654

Күн бұрын

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!
joelting.com/sap-ebook/
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
💻 My Personal Laptop, Legion 5 Pro - amzn.to/3nZrn1I
✈️ My Travel Companion, Macbook Air M1 - amzn.to/43jLLuE
📷 My Camera Gear, Sony ZV-E10 - amzn.to/40T7uIj
🤝 BE MY FRIEND:
🐦 Twitter - / joelting92
🏢 Linkedin - / joel-ting
🙎🏻‍♂️ WHO AM I:
I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity.
📧 GET IN TOUCH:
If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.

Пікірлер: 113

@JoelTing 18 күн бұрын

I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below: ko-fi.com/s/c366da7e71

@M4KE4W1SH 2 жыл бұрын

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

@stevejohnson5033 2 жыл бұрын

Another awesome video. Keep them coming.👍

@user-wo3mu9bc4j Ай бұрын

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

@NguyenTrang-cx7rd 2 жыл бұрын

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

@satyanarayanamurtykodukula3087 2 жыл бұрын

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

@prasenjitmandal5486 9 ай бұрын

It's Very Useful ! Amazing

@nitinshevkani3467 2 жыл бұрын

Good tips Joel, 👍

@maymangundayao 4 ай бұрын

Great help. thank you so much

@anilnagane3732 Жыл бұрын

Thank you very useful 😊

@rajeshrazz6496 2 жыл бұрын

Thank you so much...Helped a lot

@JoelTing 2 жыл бұрын

Glad it helped!

@JoelTing 2 жыл бұрын

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!

@udaykumarkamasani1022 2 жыл бұрын

Really helpful for me. Superb bro

@JoelTing 2 жыл бұрын

Glad to hear that!

@yogeshloganathan8221 Жыл бұрын

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

@karmaestark 2 жыл бұрын

Hi, muchas gracias por compartir el conocimiento

@JoelTing 2 жыл бұрын

Thanks again!

@rupalineema4925 2 күн бұрын

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.

@Nipunj9 2 жыл бұрын

👍

@minxu8004 2 жыл бұрын

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?

@JoelTing 2 жыл бұрын

You can get today's date by using the method "Date()". Depending on how your SAP GUI is being set up, to get today's date in your desired format, you can use the following: Format(Date, "mm.dd.yy") or Format(Date, "mm/dd/yy")

@vishal-gg1hk Жыл бұрын

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 ?

@JoelTing Жыл бұрын

Hi, not too sure about this. I have not personally encounter this before. Once you hit the record button, nothing in your user interface work?

@jollestmc5528 Жыл бұрын

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.

@JoelTing Жыл бұрын

Hi Jollest Mc, when you mentioned that it failed at the point of Create Actions, do you mean when it is running the SAP VB script? Or are you using Click UI element etc to access the data input field?

@emilblack02 Жыл бұрын

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).

@JoelTing Жыл бұрын

Hi there. if XLSX format is not available, would it work if you try to work with XML format instead?

@emilblack02 Жыл бұрын

@@JoelTing it does! But every time I execute the script it stops at the saving part because of the pop-up window (save as)

@JoelTing Жыл бұрын

@@emilblack02 can you try to check if the setting "Show native Microsoft Windows dialogs" is disabled at your end under "Option" > "Accessibility & Scripting" > "Scripting"?

@luiscamarena3625 Жыл бұрын

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?

@JoelTing Жыл бұрын

Hi Luis, If it's not set to allow, sometimes it may intervene with the script. But anyway, you can try running a recorded script and see how it went.

@SimpleExcelVBA 2 жыл бұрын

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

@JoelTing 2 жыл бұрын

Hi SimpleExcelVBA, Right click anywhere on the grid in SAP and click on spreadsheet. It should give you the option to untick the always use selected format again

@JoelTing 2 жыл бұрын

Btw, thanks for watching. I have watched your video before and it kind of get me started with SAP Scripting. Thanks a lot of your video as well! Appreciate it.

@SimpleExcelVBA 2 жыл бұрын

@@JoelTing Wow! Thank You. Really nice to hear that! Let's stay in touch in case of any issue connected with SAP or any programming issue :)

@786VIMAL Жыл бұрын

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)"

@JoelTing Жыл бұрын

Hi there. Have you logged into SAP and in an active session already? The script is not able to find a SAP session to connect to. If it is already opened, then it may be due to scripting being disabled/not enabled by your company.

@gonzaloalvareznavarro6321 2 жыл бұрын

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

@JoelTing 2 жыл бұрын

Hi Gonzalo, I believe we are not able to disable to auto open. But, I did some search and found something that is working for me in SAP forum. We can choose to close the exported excel file with the following function. Sub close_excel_instance_sap() Dim xlApp As Object ' Use the Excel file full path. Just the filename of the workbook will not work' Set xlApp = GetObject().Application ' close the exported workbook' xlApp.Workbooks(1).Close False ' close the excel instance' xlApp.Quit End Sub

@masjaf1992 Жыл бұрын

Joel, and how to connect to SAP neatwever 6,5 ? Something change ?

@JoelTing Жыл бұрын

The script may differs from different SAP netweaver versions. You will need to change the top portion based on what you have recorded, but the concept is the same fundamentally.

@dcpowered Жыл бұрын

Hi Joel, the VBA script fails when in SAP it is needed to paste one code first to enable the list option for pasting a list of codes to extract. Is there a solution to this?

@JoelTing Жыл бұрын

Similar to what you will do previously, during your recording, paste one line first, then click on the list option and then paste in. When you are making it dynamic, when pasting the 1st line, you can use the first element in the list, then proceed with pasting the rest after the list option is available. Will that perform what you expect?

@andresdavidrodriguezzamero2086 3 ай бұрын

Hello Joel, sorry for the inconvenience but I have a question! When I create the script, the save as windows window appears and the script does not record those steps, however, so that the format between SAP and Excel does not change, I have to download it that way, giving save as to the file. A few days ago I managed to find the code for the macro that did it but now I can't find it, do you know how to make my macro continue and save the file?

@JoelTing 3 ай бұрын

Hi there. You can check out one of the suggestion here in SAP community. community.sap.com/t5/technology-q-a/how-to-handle-save-as-dialog/qaq-p/648415 This suggested approach is using key strokes to switch between controls in the dialog. If the timing was not set right, it will break at times.

@andresdavidrodriguezzamero2086 3 ай бұрын

@@JoelTing Thanks Joel!! but I have not been lucky! Let's see if I keep looking! I'll keep you informed

@sanjeewasamaranayake 7 ай бұрын

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.

@JoelTing 7 ай бұрын

Hi there. I personally have not encounter this before. Do you have the specific error code? How about you try changing the Application.DisplayAlerts property for Excel to be False before running the script and set it back to True after running the script? Usually this will disable alert messages when macro is running.

@sanjeewasamaranayake 7 ай бұрын

@@JoelTing Thanks Heaps. This worked for me. I had 3 transactions that has this issue MB25 (Material reservations via MM system), IW39 (PM system) and one of our custom transactions to get payroll hours info

@_cimbora 2 жыл бұрын

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

@JoelTing 2 жыл бұрын

Hi Amit, I'm not sure how that would work though. You can try developing your script in quality system, then log off from that and log into production system before running the script. Would that work?

@amitsinghbohra7539 Жыл бұрын

@@JoelTing thanks man🤘.... I'll explore this option as well.

@keireigo6425 2 жыл бұрын

Dear Joel, thanks a lot for the amazing video. But I cannot find the ‘sapfewse.ocx’ file on my desktop. 😭

@JoelTing 2 жыл бұрын

Hi keirei go, you are still not able to find it using the browse button and changing the file type to ActiveX Control? Just wanted to understand, are you using Citrix so access SAP GUI? I have encountered some instances where Citrix is being used, and the script will not work in VBA.

@abdulelahalfi5504 2 жыл бұрын

I really have a concern. Can you run a recoded sap gui macro with Sap not open?

@JoelTing 2 жыл бұрын

Hi Abdulelah Alfi, no. SAP GUI macro functions by imitating user clicks and interactions with SAP GUI. So it needs to be opened to be ran.

@kotipallisowmya8410 2 жыл бұрын

Hi Joel, I have an issue in selecting layout in SAP while running the script in Macro. I have set my default layout while recording the script and Macro is working on the same day with default layout but when I am running it after 2-3 days layout is changing so the output I want is not coming with the changed layout. Can you help me how to fix this issue?

@JoelTing 2 жыл бұрын

Hi kotipalli sowmya. In that case I would recommend you to record a version where you type in the layout name into the layout textbox. Avoid using default as this may be changed by others, resulting in inconsistent output. SAP Scripting only helps you to perform repetitive steps. As much as possible, we want to avoid using settings that may change the outcome.

@kotipallisowmya8410 2 жыл бұрын

@@JoelTing thank you for your prompt reply but unfortunately there is no text box to type in the layout name for the T code I am running

@JoelTing 2 жыл бұрын

@@kotipallisowmya8410 how about you add in the steps to select your layout via a search? Every run, click on the select layout button, then search for your layout. Then click accordingly, see if the scripting is able to replicate searching for your layout

@kalyanamurti4624 Жыл бұрын

Hi, How to do copy-paste from clipboard in VIM (SAP) using SAP GUI VBA?

@JoelTing Жыл бұрын

Hi Kalyana, when you copy using Ctrl+C, is the scripting recording tool able to capture the shortcut or keystrokes?

@kalyanamurti4624 Жыл бұрын

@@JoelTing I saw one of your video about VBA - SAP GUI and I found the solution in it. Thanks a lot.

@JieyingJY Жыл бұрын

Hi Joel, I’m unable to find the SAP GUISCRIPT in my desktop even after follow your steps here… may I know is there any other ways that can help?😢

@JoelTing Жыл бұрын

Hi there, are you using SAP GUI remotely like with Citrix?

@tallalaazmi1287 Жыл бұрын

Hey Joel! Having an issue......the macro is running smooth on my system but cannot run it on my colleagues' system, Prompts an error on the first step!! Any idea?

@JoelTing Жыл бұрын

Hey Tallal Aazmi, do you know what's the error code they are having?

@tallalaazmi1287 Жыл бұрын

@@JoelTing Hello Joel, Sorry for the replying late, I've getting this error Runtime-Error '-227221020(800401e4)': Automation Error Invalid Syntax

@JoelTing Жыл бұрын

Hi Tallal Aazmi, is the SAP GUI Scripting API enabled under reference in your colleagues' system?

@laradanicalim3954 Жыл бұрын

Hi, Joel. The script works fine for me. But when another user tries to use the script, it gives them a compile error: Variable not defined in this line: Set objConn = objGui.Children(0) We've configured the SAP settings already and did the excel preparations, etc. before running the script. What I suspect is that it's because I recorded and tested the script in the 'development system' and the user is trying to run the script in the 'production system'. I'm not sure though The script recording is allowed only in our development system. However, we have configured everything already in the user's production system before we ran the script.

@JoelTing Жыл бұрын

Hi Lara, If that's the case, that means that users are blocked from executing any SAP GUI script in the production server. Usually that needs to be enabled by admin in transaction RZ11 sapgui/user_scripting for the production server.

@laradanicalim3954 Жыл бұрын

@@JoelTing This was really the case 😅 Anyway, thank you so much!

@manishsoni125 5 күн бұрын

Hi joel when i try to record SAP Gui scripting i get the error of directory does not exist please help on this

@JoelTing 4 күн бұрын

Hi, would it work if you rename the Save To field to a directory that you know does exist?

@bhanukax3063 2 жыл бұрын

I have tried several time to enable script recording with given tips but still that option is disabled. Please help SAP logon 730

@JoelTing 2 жыл бұрын

Hi Bhanuka, may I know if there's any error shown when you are trying to enabled the option? Or is that option being disabled and greyed out all the time? If it's always disabled, chances are it's due to the company blocked its user from using scripting and there's not much that can be done (other than asking IT/admin to enable it in server) from a user perspective.

@travelbark1013 5 ай бұрын

Hey Joel do you know how can we pass multiple document no in one shot during automation (to avoid loop repetition ) . Please suggest , Thanks in Advance

@JoelTing 5 ай бұрын

Hi there, do you mean copy and paste using clipboard?

@travelbark1013 5 ай бұрын

@@JoelTing no during Automation we are using loop ...but bot pick one document no from excel then put in SAP ... but my requirement how can our bot will go for 10 document in one shot

@JoelTing 5 ай бұрын

Are you able to do it in bulk in SAP manually? If yes, you may be able to replicate it in the script. But if it's not, there's simply no such option. SAP GUI script is just helping you to do the work. If SAP GUI only accepts one document at a time, then my understanding is that the only option for the script to run is via a loop.

@travelbark1013 5 ай бұрын

@@JoelTing yes I am able to run manually

@JoelTing 5 ай бұрын

When you are doing it manually, I believe you are using a simple copy and paste? You can record the script to use the upload from clipboard button. Before running that line, use the range.copy() method to copy the range and click on the "Upload from Clipboard" button using the script. This way, it will be pasted into SAP like how you did manually.

@martinkamunya9300 Жыл бұрын

How do you address error " Invalid GUI input data: FOCUS DATA"

@JoelTing Жыл бұрын

Hi Martin, I have personally not faced this error before. Do you mind sharing which specific line result in the error?

@bijeeshp5784 Жыл бұрын

How to disable auto opening of sap downloads in excel?

@JoelTing Жыл бұрын

Hi there. Credits to Patrick Migues, he suggested to try the following: Dim export1 As Object Dim export2 As Object Set export1 = GetObject(“file location\Export 1.file extension”).Application Set export2 = GetObject(“file location\Export 2.file extension”).Application export1.Workbooks(1).Close export2.Workbooks(1).Close export2.Quit Error Situations: This will close either all of the Excel files opened after the Macro is run, explicitly listed or not (running correctly); or it will close all of the excel files opened prior to running the macro, to include the file running the Macro, if one of the explicitly listed files is not open or saved to the listed location. Because of the above, when this code fails, it will not throw a debug error. I gave up working on that part as I felt like it's not a good use of my time to keep trying and debugging this one simple action of closing the workbook, since I automated the most time consuming part.

@yudimuttaqin205 5 ай бұрын

Hi Joel, I got a runtime error "432" File name or class name not found during Automation process, referrring the the line "Set SapGuiAuto = GetObject("SAPGUI"), please help thanks

@JoelTing 4 ай бұрын

Hi there. May I know if you have SAP GUI Scripting API enabled?

@yudimuttaqin205 4 ай бұрын

@@JoelTing yes i have enable it following the instruction via Excel options setting

@JoelTing 4 ай бұрын

@@yudimuttaqin205 personally I have not encounter this error before. Another way you can try is to check your recorded script. Look for the same Set SapGuiAuto line, and check whether the object is "SAPGUI" or another name. There's some system where the object is "SAPGUISERVER" instead.

@user-jz5wg6mh2o 11 күн бұрын

I want enter data from excel cell. But it's getting entered SAP cell number only in SAP. Pls let me know how to add variable data from excel cell.

@JoelTing 10 күн бұрын

Hi there. I'm not sure if I understand you correctly. I believe you are trying to send data from different Excel cells into SAP. If my understanding is correct, you can refer to the link below on how this could be done: joelting.com/articles/sap-gui-script/send-data-from-excel-to-sap-gui-with-excel-vba/

@kalyanamurti4624 Жыл бұрын

Hi, what is error 619 and how to solve it?

@JoelTing Жыл бұрын

Hi Kalyana, this seems to be happening when the script cannot find the buttons/boxes to activate as written in your script. You may try debugging it step by step, see which step does your script goes wrong then determine how to fix it. Maybe some of the steps are not working as expected

@mohammadsuheb.l9872 11 ай бұрын

Am getting debug error how to fix that

@JoelTing 11 ай бұрын

What debug error you are getting? There's a lot of possibility and it will be hard to know what went wrong without knowing the details.

@MukeshMishra-kl2fn Жыл бұрын

I am getting an error while trying to log on to SAP. Click failed ( failed to get UI element)

@JoelTing Жыл бұрын

Hi, are you at the same page as when you first started recording?

@MukeshMishra-kl2fn Жыл бұрын

@@JoelTing yes. Moreover, when I get logged onto SAP I observe that my PAD recorded does not recognize the various UI elements on the page.

@MukeshMishra-kl2fn Жыл бұрын

@@JoelTing Even when I try to click any text box on the page, PAD shows only a Pane and not that particular UI element. Please help me. My company wont give the previleges for record & playback scripts. My only change is through desktop recorder

@JoelTing Жыл бұрын

@@MukeshMishra-kl2fn unfortunately, PAD recording function does not work with SAP GUI. It is not able to capture all the elements. If your company do not allow record & playback scripts, you will not be able to record or execute any SAP automation scripts.

@MukeshMishra-kl2fn Жыл бұрын

@@JoelTing Ok thanks for clarifying.

@xeemv6726 2 жыл бұрын

I still don’t have SAP GUI API

@xeemv6726 2 жыл бұрын

Please I need your help

@xeemv6726 2 жыл бұрын

Btw, thank you for the helpful video, but still I can’t use SAP GUI APi

@JoelTing 2 жыл бұрын

Hi xeemv, just wanted to understand, did you have SAP GUI installed in your local computer? Or is it accessed via Citrix? If it is via Citrix, then, you wont be able to use Scripting with Excel VBA as it is not able to communicate with it.

@vijayj3296 Жыл бұрын

Some time I get below error...how to fix it... Run-time error ¹-2147418110 (800 10002)': Method 'FindById' of object 'ISapSessionTarget' failed

@JoelTing Жыл бұрын

Hi Vijay, you can try to troubleshoot step by step. See which step is giving the issue. For findbyID error, you can check if the error is triggered because the script did not manage to navigate to the page like what was recorded.

@vijayj3296 Жыл бұрын

@@JoelTing it showing error to Session findbyid (wnd [0]".Maxmize In drag the above to watch window under Value -