Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]

Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]

Cust&Code in SAP ABAP

1 год назад

20,465 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

그냥아는사람
그냥아는사람 - 20.11.2023 04:15

Thank you for your video. That was very helpful. Can I ask you a question? Is there a way to download all the files attached to the Sap accounting slip by using Guiscript? I don't know how to download the whole thing because the number of attachments is different for each slip.

Ответить
satyam malhotra
satyam malhotra - 13.11.2023 22:10

Hi Sir, Hope you are doing good.
Could you please help me with any formula/vba code for taking dynamic date. Means i always have to extract the data for open line items appearing in end of the month.

Your help would be highly appreciated.

Many thanks for the video and sharing knowledge with us😊

Ответить
Valentin Mantoiu
Valentin Mantoiu - 27.10.2023 10:09

Hi, getting a runtime error 614, any help please?

Ответить
Nathan Martin
Nathan Martin - 26.10.2023 10:15

Tanks for the video it Washington vers helpful!! I just have à question : how do I do to work on a Excel sheet after closing the SAP part ? My code "Application.ScreenUpdating = False" doesn't work...

Ответить
ZEESHAN AHMAD SIRHINDI
ZEESHAN AHMAD SIRHINDI - 17.10.2023 13:57

Use full video, one question "Can we use VBA (macros) to upload file from excel to SAP" ?

Ответить
vijay senthil
vijay senthil - 12.10.2023 14:36

Thanks for your vedio its very easy to understand

Ответить
Jesse Nethononda
Jesse Nethononda - 10.10.2023 15:44

awesome stuff man. How do I export SAP data/excel to the Macro enabled spreadsheet. In a way the spreadsheet becomes an app for data extraction...

Ответить
surajkumar mahto
surajkumar mahto - 29.09.2023 23:36

Hi thanks for this its very helpful ....just one query that i wanted to extract data in same. Excel file in which i have created button pls.. help in this

Ответить
Carla Arenas
Carla Arenas - 16.09.2023 04:44

Hi Sir do you have a video that I can follow regarding for example I need to create Info record using transaction code ME11 then I will create Macros and I will run using that. I believe I need to create some headers right?

Ответить
ahmad ghozie
ahmad ghozie - 15.09.2023 06:38

Hi Sir,
I just try to follow your video. After I create the Macro, and Run the Macro, it didn't work. There's a notif on Microsfot Visual Basic dialog box said that " Run-Time error '619' : The Control Could not be found in id".
please help

thank you

Ответить
Mr Ronaldino
Mr Ronaldino - 09.09.2023 11:37

Thank you so much this will help me a lot as data analyst. However I am not authorized to use tcode RZ11. I will definitely raise a ticket for this for automation purposes!

Ответить
Karim MOHAMED SALAH
Karim MOHAMED SALAH - 30.08.2023 10:40

thanks the video is very helpful i did it in a few minutes, but Sap needs to be opened, can you please support on how to embed in the VBA Code to open SAP automatically? and also how to make it extract automatically at a certain timing

Ответить
Priti Rawat
Priti Rawat - 28.08.2023 14:44

This was very helpful!

Ответить
Carlos Eduardo Araujo
Carlos Eduardo Araujo - 15.08.2023 16:30

Very didatic video. Thanks a lot!

Ответить
مريوم العشوان
مريوم العشوان - 03.08.2023 08:15

Thank you for your video.what if l want to write a code to close excel file after export it??? Please your support will be appreciated

Ответить
Mohammad Suheb.L
Mohammad Suheb.L - 24.07.2023 18:22

How to set the date from and to?

Ответить
ezgi nagihan Gokler
ezgi nagihan Gokler - 19.07.2023 17:18

wow tahnk you , you are a hero :D

Ответить
xIKingxBlack
xIKingxBlack - 28.06.2023 20:55

Thanks for this video!

Today i made a similar macro for a transaction i need.

But i would like to improve the macro a bit.

I want it to check, whether SAP is already open, if not it should open SAP and log in with my username and password, if its already open, i should just start doing the steps

Do you know how i could do this?

Ответить
kapi bara
kapi bara - 25.05.2023 09:16

Fantastic video! Thank you sir 😊

Ответить
Sãmûvël Ràjáñ
Sãmûvël Ràjáñ - 18.05.2023 18:09

copy paste function is not working while recording scripts

Ответить
Dinesh Shelke
Dinesh Shelke - 07.05.2023 08:09

Thanks for making this video
I need your help where can we connect?

Ответить
Furkan Dirik
Furkan Dirik - 25.04.2023 12:29

Awesome

Ответить
Ralf Neitzel
Ralf Neitzel - 25.04.2023 08:19

Thank you! Very helpful!

Ответить