Question Re: SAPGUI Scripting Full Documentation in Technology Q&A

SAPGUI Scripting Full Documentation

Former Member — Tue, 14 Jul 2020 13:14:54 GMT

Hi,

Does anyone know where I can find a full documentation for SAPGUI scripting?

I have been using late binding in VBA and copying codes from recorded SAPGUI scripts into VBA but it would be much better if I can have a full list of available objects and methods to work with.

Thank you

Regards

Jay

Re: SAPGUI Scripting Full Documentation

jerryjanda — Tue, 14 Jul 2020 13:16:31 GMT

Hi, Jay:

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

--Jerry

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Tue, 14 Jul 2020 13:20:42 GMT

From SAP GUI, menu "SAP GUI Scripting Help" below "Script Recording and Playback".

Or online here: https://help.sap.com/viewer/product/sap_gui_for_windows/760.02/en-US?q=SAP%20GUI%20Scripting%20API

Or online here: https://archive.sap.com/documents/docs/DOC-8971

EDIT July 16th 2020 : also in menu "SAP GUI Scripting Help" of SAP GUI

Re: SAPGUI Scripting Full Documentation

daniel_mccollum — Thu, 16 Jul 2020 02:05:03 GMT

I'd always gone to the help from the GUI

I like the PDF more 🙂

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Thu, 16 Jul 2020 09:35:16 GMT

daniel_mccollum you say "the help from the GUI", but I'm not aware that the documentation of "SAP GUI Scripting API" is available in the SAP GUI help... (there's only the help for SAP GUI end user, not help for developer)

Re: SAPGUI Scripting Full Documentation

Former Member — Thu, 16 Jul 2020 13:15:46 GMT

Thank you Sandra,

I have been using the below code in my VBA macros to connect the SAPGUI.

Dim SapGuiAuto, SapApp, SapCon, Session As Object

'Initiate SAP Connection 
Set SapGuiAuto = GetObject("SAPGUI") 
Set SapApp = SapGuiAuto.GetScriptingEngine 
Set SapCon = SapApp.Children(0) 
Set Session = SapCon.Children(0)

I have read the PDF document before but the objects and methods in it don't seem to be available in VBA.

Could you show me how to use them in VBA please?

Thank you very much

Regards

Jay

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Thu, 16 Jul 2020 13:34:20 GMT

I don't understand what PDF you guys are all talking about... (the only PDF I see is "The SAP GUI Scripting API", presentation by Cohrs and Loff, which doesn't talk about objects and methods, other documents are in HTML or CHM format).

The preferred language is VBS, not VBA. If you want to use SAP GUI Scripting with VBA (i.e. via macros within MS Office applications), it should work with MS Office 32 bits, but not 64 bits unless you use the method explained in the note 2689304 - Usage of SAP GUI Scripting ROT Entry Helper (saprotwr.dll) by 64bit applications, which corresponds to the "DLL Surrogate" approach.

Re: SAPGUI Scripting Full Documentation

jude_bradley — Thu, 16 Jul 2020 14:20:16 GMT

Hello Jay, document, you will find in the DOCU folder of your downloaded SAPgui installation.

\Presentation_CD_1\<sapgui version>\DOCU\ SAP_GUI_Scripting_Security.pdf

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Thu, 16 Jul 2020 15:00:49 GMT

It only concerns the security. From the SAP GUI, there's the menu "SAP GUI Scripting Help" below "Script Recording and Playback", which displays the documentation for SAP GUI Scripting API.

Re: SAPGUI Scripting Full Documentation

daniel_mccollum — Fri, 17 Jul 2020 00:48:26 GMT

Seems like you've already updated this in the edits.
Opens the local file.

Re: SAPGUI Scripting Full Documentation

Former Member — Fri, 17 Jul 2020 01:25:39 GMT

Thank you Sandra.

Sorry I can't access the link.

I'm a newbie in this and don't really understand what "DLL Surrogate" means. 😛

At the moment, I'm using the SAPGUI script recorder to record VBS code and then copy them into my VBA code, which all use the method "FindByID".

If I understood this correctly, it seems the "FindByID" method is the only method available for Office 64 bits?

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Fri, 17 Jul 2020 04:04:41 GMT

Jay Geng "All use the method FindById" just because your recorded actions were simple and didn't imply other methods. It generates VBS code. VBS works by running the VBS file from Windows File Explorer from instance.

VBA looks like VBS, but it's not VBS. If you copy the VBS source code to a VBA macro, it may NOT work at all as I explained.

By the way, maybe you have other problems with your code. Could you explain what error message you get, at what line?

Re: SAPGUI Scripting Full Documentation

Sandra_Rossi — Fri, 17 Jul 2020 04:05:12 GMT

Daniel McCollum Thanks. It's a CHM file in my SAP GUI installation, not a PDF.