SAP GUI Scripting - Extract SAP report data to Excel

This video provides and example of running GUI scripts to export table contents via SE16, or queries via SE38. This data is exported to CSV and loaded to Excel to be manipulated there.
GUI scripting allows external applications like MS Excel to connect to an existing GUI session and execute operations within the GUI. Excel does not hold and authorization and access information as it relies on you logging into SAP first.
This example is in CRM but it can be used in any GUI based SAP system.

All my GUI scripting files on Github (in case you cannot access the above link):

[xdriveawd]

This 18 minute video saved an hour of my working time. Thank you so much for your kindness in sharing a valuable skill and knowledge.

[cesarbuitrago]

Hi
Csongor Varga, I am very grateful to you for being very supportive of the subject and for helping me to improve the productivity of various applications that I have automated with excel.
a hug from colombia and blessings.

[esnoy]

MI amigo, quizás usted no entienda español y yo muy poco de Ingles, de verdad que fue de gran ayuda en este día. Saludos.

[carolatton]

Anxious to start using this to download a lot of various data on a weekly and monthly basis. Thank you for your informative videos and the template!

[robertdevadason]

Very useful video...gonna try this...will help me save time on downloading data and preparing reports on a weekly basis. thanks man

[tahwnikcufos]

So, this could be used to run multiple transactions synchronously, while putting the results in their corresponding tabs - correct?

[grzegorzdziewiaty]

Thank you for this and the first video, it helped me to create cool application.

[AnimateYa]

I can't use the connection, I then declare next variables: dim connection, and dim application. When only paste all code of scripts, my application run perfect. But have advertised on the excel: error "esperando que otra aplicación complete una acción ole" en excel 2016. You have solution.

[ba_golf]

Hi, thank you for the video. How do I then format the extracted data as a table? Can this also be included in the script? Many thanks.

[astrys]

Thanks for the series and the effort, though what is "DCG210"? How can I find this value for my specific system?

[riccardocaruso]

Cool video! Thank you.
But do you know how I can find the "sid and client to connect to
":

' Set the sid and client to connect to
W_System = "DCG210"??

[samueljunioryimga]

Hello thanks for the video. love it . But what happens when you have many variant and you need to select one in particular?

[neeleshagarwal]

worked wonderful. Thank you so much for your time and great attitude of sharing the knowledge. :)

[notengo]

Hello, I need to extract data from a long tex field where session.findbyID does not report any text or value. How can I do that? Please help.

[eugeniopazrodriguez]

Hi, I cannot get the final file (XLS file coming por SAP) I don't know why, at the end of the run, I have to write the name and the path to download the file. I want to go across the record and export automatically. Someone can help me please?

[Giggio]

Hi! Thank you for this tutorial!

Quick question: I'm importing a column that contains both numbers and text infos from SAP. The text cells are not being recognized as text, it fails when I try to use the data in a Excel function. I've been trying to find a solution for a long time now..
Do you guys have some tips to fix it?
Thank you

[romanakondrlova]

Thank you very much for this video and material! VERY HELPFUL! Good job! Keep up the great work! :)

[eechaze]

You make this so easy to follow. Thanks

[AnkulBaranwal]

Hi,
Can you tell me how to extract the log for the opening and closing of the accounting period? What is the T.code for extraction of a log from SAP?

Thanks!

[Toxice]

You mentioned that you used to use it to extract multiple reports at once, i would like to do a similar thing and extract multiple reports (different data points) from the same sap transactions, how did you make it loop and chose to run it for multiple reports ? thanks in advance.