I try to work within SAP of course, but sometimes I also export SAP data to Excel. Helpful video

Ya

@@dhruvdevsingh9907 Great

I appreciate your support. Thank you

Vielen Dank Toni. Es ist immer gut, wenn man sich die Arbeit erleichtern kann :)

Das freut mich sehr. Viel Erfolg.

You're welcome, Sir

Thank you so much 👍

I am happy to help

Danke 😊

Thanks 👍

Thank you so much

Appreciated

@@ERP-UP the record window of my SAP doesn't have the playback option. Is there a way to activate it?

@@tiagobovolin Sure, have a closer look at this video: kzfaq.info/get/bejne/odGVZKyS05q9fnU.htmlsi=azCFs8d3k7icJv0p&t=31 In the transaction RZ11 maintain the profile parameter sapgui/user_scripting_disable_recording

@@ERP-UP Thank you.

👍

For this you need to do a second step because sending the excel sheet out of Excel can't be recorded via SAP GUI Scripting and is therefore not in the created VBS file. You can send an excel sheet via e-mail out of excel to people's emails also. Have a look at this: techcommunity.microsoft.com/t5/excel/how-to-create-a-macro-that-allows-to-automatically-send-a/m-p/3932382

👍

Thanks. You can record your download within the SAP GUI Scripting as shown in the video. You can stop the recording until your download from several t-codes has been finished. But I recommend to record one SAP GUI Script for each t-code to have it separated.

Thank you so much. In this case you want to get SAP data into an existing excel file. If you want to add SAP data into an existing excel file you need to establish an connection out of Excel. This is possible with a connection directly to the database. In Excel see "Data > Get Data > From Database > SAP HANA". Then you also need to have "Acces Software Downloads in SAP for Me". You can also use ODBC. As an alternative you can download/extract the SAP data into the excel file and use this file as the data source of your excel file (Data > Get Data > From File > From Excel Workbook). I can produce an own video on that. Good hint.

You can use the dynpro based file save dialog as shown in the video 9:44. For this you have to implement the SAP note 1974590 and the SAP GUI option When you record your SAP GUI script a dynpro based file save dialog should appear if you don't activate the SAP GUI option "Accessibility & Scripting > Show native MS Windows dialog".

This is possible. When you record the steps, a vbs file is created. In the vbs file you can program the format you need in the Excel file.

Technically it is possible. Therefore you have to set up a scheduled task within Windows Task Scheduler for the created vbs file. But the SAP GUI has to be open because SAP GUI Scripting runs in foreground. If you really want to export the data in background daily I recommend to create an ABAP program and set up a batch job in the transaction SM36. kzfaq.info/get/bejne/ast4n6yd096ZlKc.htmlfeature=shared

You can use Power Automate instead of SAP GUI Scripting: learn.microsoft.com/en-us/power-automate/guidance/rpa-sap-playbook/action-based-sap-gui-automation-recorder-overview You can use the Task Schedular to run the VB script at a scheduled time.

Have a look at those answers: answers.sap.com/questions/13523338/prevent-or-close-exported-files-from-sap-gui-to-ex.html stackoverflow.com/questions/64009373/close-sap-export-multiple-excel-file-with-vba

Thank you is working

Hey, how do you export the data? Have a closer look at ABAP2EXCEL if you program an own ABAP report with an export function from SAP to Excel: kzfaq.info/get/bejne/m7dgmq2r1czaopc.htmlsi=WbngeqrvxXH9nGZr

What do you mean with "SAP screenshots"? You can simply take screenshots with the print key and "Ctl + V" to paste it into a word document. I recommend using the key combination "Windows key + Shift + R" to easily take screenshots of a frame of your screen.

@@ERP-UP I saw a video kzfaq.info/get/bejne/jcV6YJylxNO7dIk.htmlsi=bSirC1R2_yW5u7sL. Just wondering why we need the SAPGUI SCRIPTING API for this process.

@@bzflowerbee Now I understand it. Thanks for replying. You want to make screenshots with SAP GUI Scripting. Csongor explained it quite well. You are using the SAP GUI Scripting API for some functions you can use for MS Excel and MS Word.

@@ERP-UP I know but I don't have the SAP GUI SCRIPTING API😭

What do you exactly mean with "individual SAP table data"? In this use case we are using the table EKKO. You can of course do it for other tables. Then you need to record another script or create an own VBA script in MS Excel to select different tables and selection criterias.

@@ERP-UP it is also possible to record the table search and selection methods?

@@ERP-UP Sorry for my inconvenience. I think I should make my own effort to solve this problem. Thx for your reply!

SAP GUI Scripting only works in SAP GUI

In this case you want to get SAP data into an existing excel file. This is possible with a connection directly to the database. In Excel see "Data > Get Data > From Database > SAP HANA". Then you also need to have "Acces Software Downloads in SAP for Me". You can also use ODBC. As an alternative you can download/extract the SAP data into the excel file and use this file as the data source of your excel file (Data > Get Data > From File > From Excel Workbook).

I don't understand the question. What type of pop-up window do you see? Why does it appear?

@@ERP-UP hello!! The Windows "save as" window appears and I need it to be able to save the file without modifying the file

@@andresdavidrodriguezzamero2086 At about 9:35 you export the SAP data and give the excel file a name. The export is not interrupted or you don't have to modify the file.

​@@andresdavidrodriguezzamero2086 Now I understand your question. Another user showed me a problem on his system. You may also mean the "save as" popup when you try to select a file in Windows Explorer. Unfortunately, there is no way to interfere with that. Maybe there will be a solution in the future.

@@ERP-UP is there a way to change the save as so that it uses the sap native option instead of the windows pop up?

03:08 - Activate SAP GUI Scripting Also make sure you enable scripting by selecting the SAP GUI option "Enable scripting" under "Accessibility & Scripting > Scripting".

That is possible. Depending on your VBS file you have to be logged into your SAP system. Try to run the vbs file without the task scheduler. If that is possible your vbs file can also be executed via the task scheduler.

@@ERP-UP my vbs opens sap gui, logs in and executes the job and logs out. It's running fine if I run directly. But doesn't get executed while in the task scheduler. I tried almost everything but I'm still struggling.

@@VedarthDesai I have created a video for this. Have a look at this video: kzfaq.info/get/bejne/aNtdo8d7vru1Y3k.html

Have a look at this video: Log into SAP from Excel with SAP GUI Scripting API kzfaq.info/get/bejne/p59mf9N5mKusZmQ.htmlsi=NsU3xiaauZW3fZu7

Have a closer look at this video: kzfaq.info/get/bejne/aZhln8-C1brIZ6c.html Excel inplace SAP GUI - Work with Excel in SAP GUI 🚀

There are 2 options to remove the automatic setting: 1) Right-click the context button in the top left corner of the output (the button between where the row titles and columns meet) and choose "Spreadsheet". 2) Or right-click anywhere in the screen area and choose "Spreadsheet". When "Spreadsheet" is selected, the automatic setting is removed.

The transaction SOAMANAGER opens in the browser (web dynpro) and not in the SAP GUI. I don't see any export function in general. If you want to you can search to export the html page into excel and transform it to your needs.