Stack Overflow
Stack Overflow

Questions tagged [sap-gui]

Questions about SAP GUI, SAP GUI Scripting, using SAP GUI (Calling transactions, setting up in the environment, customizing, etc.)

"SAP Graphical User Interface" (SAP GUI) is a legacy SAP front end tool available for various desktop environments (Windows, Mac, Java) and as an HTML web application.

It also comes with SAP GUI Scripting, an API that allows users to automate repetitive tasks by recording and running macro-like scripts (VBS and others for Windows, JavaScript for Java).

720 questions
0
votes
0 answers

SAP RFC Connection with VBA - BAD VARIANT TYPE

I'm having a problem with the SAP RFC when I'm trying to download some tables. When I try to create the connection I get the following error: Bad Variant Type I checked the regedit registry for RFC and it is all right. The IT installed the SAP…
zanniboni
  • 13
  • 5
0
votes
0 answers

How to copy data from SAP GUI to Excel with VBA?

I would like to automate several transactions, so I import my data into a buffer file (I would prefer ".txt" format). Then I will use this buffer file which will always have the same name for the example (TEST.txt). Then I want to copy this data to…
Guimove
  • 17
  • 7
0
votes
1 answer

Trouble converting VBA SAPGUI code to VB.NET can't find proper imports libraries

I'm trying to convert code I wrote in VBA (from Access 2013) to a new VB.NET platform. I'm assuming I need to import a SAPGUI reference but can't find where to find it! I went into the package manager and installed the ... Install-Package…
Peter
  • 148
  • 1
  • 2
  • 18
0
votes
1 answer

How to copy and paste data from SAP GUI to Excel?

I saved my script and connected it to VBA, then I want to copy my local SAP GUI data into an external Excel file. Sub FOS() If Not IsObject(App) Then Set SapGuiAuto = GetObject("SAPGUI") Set App = SapGuiAuto.GetScriptingEngine End If ... …
XDSSIOP
  • 91
  • 3
  • 11
0
votes
2 answers

Why does a macro assigned to a cell fail?

I have a macro assigned to a cell that executes once clicked on. The macro involves SAP GUI scripting, which if ever interrupted (via CTRL+DEL+ALT), also causes my previously clickable cell to stop working. I can run the macro via Developer yet the…
vlad_milovanovic
  • 31
  • 6
0
votes
1 answer

How to continue running a VBA macro when an SAP GUI popup message says no data found?

When the SAP GUI script searches for data via SAP GUI and finds nothing, it sends us a pop-up message saying "that it has not found any data", how to keep the macro running because later there are other transactions. Sub FOS() ... On Error…
XDSSIOP
  • 91
  • 3
  • 11
0
votes
3 answers

SAP GUI Automation using C# - does sapfewse.ocx have a written developer documentation or api library?

Referring to this question here a past user was able to develop some C# code to perform SAP GUI Automation. However when looking online at tutorials/developer documentation for this library I was unable to find anything. There are a lot of objects…
Jebathon
  • 4,310
  • 14
  • 57
  • 108
0
votes
1 answer

script recording and playback, and excel

I want to automate a transaction on SAP using the playback script. I record a transaction and then export it under excellent all while remaining on SAP, it works perfectly. (this is the Microsoft Excel icon, Ctrl+Shift+F7), this is an icon with an…
XDSSIOP
  • 91
  • 3
  • 11
0
votes
1 answer

How to loop at lines in worksheet?

I get an Excel file with a list of around 500 documents every day and I need to download attachment from SAP system for each document. I recorded a SAP GUI script but I am unable to loop through all the documents. Need help. I need to enter document…
chandrakanth k
  • 1
  • 3
0
votes
1 answer

How can i use some SAP scripting from windev?

I have a windev programm that needs to access some SAP data. Because of my company's restrictions, i cannot use the SAP native access provided with WinDev. So, How can I use vba code that uses SAP from windev? This is for a .exe programm for…
Samuel
  • 59
  • 9
0
votes
1 answer

How to disable the Excel display with SAP GUI Scripting automatically

I recently discovered SAP GUI Scripting. First I started to record easy transactions because I wanted to test if it is possible to execute the script on different PCs with different windows and SAP users. During the testing phase I bumped into one…
MRVN
  • 3
  • 1
  • 6
0
votes
1 answer

Code for deleting specific rows / line items

I have created a SAP GUI script to delete PO's in SAP. As long as PO is containing one line item the script is fairly straight forward. But what if I have PO's with more than one line item and I want to delete only specific item/row on the…
Adde
  • 45
  • 2
  • 10
0
votes
1 answer

back to SAP initial screen from VBA

I have an excel macro that uses SAP-code created by the built in sap-scripting. It works fine, but I need to perform those steps more than once on different tables. The problem I have is that I cannot simply trigger the first step, as at that moment…
user10957064
  • 9
  • 5
0
votes
1 answer

Is there a way to make a SAP GUI code work for all versions?

I have a SAP gui script that works for me and does what i want to, so no problem with this. The thing is, with my coworkers, which are supposed to use my code too, my SAP gui script does not work. For example My script on SAP…
Samuel
  • 59
  • 9
0
votes
1 answer

How to check the error while login SAP GUI via Python codes

I try to log in the SAP GUI by Python, but after I run the codes, I got the following error connection = application.OpenConnection("A101.TA2", True) File "", line 3, in OpenConnection pywintypes.com_error: (-2147352567, 'Exception…
Leon
  • 1
  • 1
1 2 3
…
47 48