How to record macro in SAP using SAP scripting

No video

How to record macro in SAP using SAP scripting - Simple Excel VBA

Рет қаралды 32,254

SimpleExcelVBA

Күн бұрын

Пікірлер: 30

@SimpleExcelVBA 3 жыл бұрын

TIME STAMPS 0:00 Intro 0:19 What is SAP scripting 1:11 How to record macro in SAP? 2:45 Structure of recorded vbs file 4:15 Summary

@chaiangeles156 3 жыл бұрын

Do you do 1on1 tutorial?

@SimpleExcelVBA 3 жыл бұрын

@@chaiangeles156 I really wish I had time for that :( If You got any questions feel free to dm me via email, I'll answer it as soon as possible.

@esmailelfadly4044 2 жыл бұрын

Thank you so much for sharing this valuable infos

@SimpleExcelVBA 2 жыл бұрын

You're welcome!

@reginaldoelgueta9061 3 жыл бұрын

Great video, Is it necessary to activate some reference in excel so that it recognizes the sap objects?

@SimpleExcelVBA 3 жыл бұрын

No, it is not necessary :)

@omkarnaik6647 Жыл бұрын

Can we use this in any other tool??vba scripting?

@SimpleExcelVBA 3 ай бұрын

Yes You can! :)

@xandros_74 3 жыл бұрын

Hi, Tomasz. Great video. I have one question. I want to export some data in a txt format. I want to do it montly and save to a file, but when I want to export, I want to put the day when I'm running the script (ex. 2020-02-01.txt). How can I make the file name a variable and not just a string? Do I have to support in any other programs like Excel or can I make it in the same .vbs file?

@SimpleExcelVBA 3 жыл бұрын

Hello, thank You. Declare variable, get the data, put inside the variable, put the variable in the place of string. That should be as simple as it sounds. :)

@phuoctran6613 3 жыл бұрын

Hi man, could you make a video about how to connect and run script from excel to SAP when it already login

@SimpleExcelVBA 3 жыл бұрын

I will do that for sure! :)

@sherrir1349 2 жыл бұрын

Can you use script recording in a purchase order for hundreds of items or same items ? Instead of line by line?

@SimpleExcelVBA 2 жыл бұрын

Record script, edit it, put the data from the table, loop it, that's all :)

@M4KE4W1SH 3 жыл бұрын

How do you “read” an inactive/blue GUI text field value in a sap table? Trying to feed the value into a cell in an excel workbook but because it’s inactive/blue (although it still may have a value) when recording it doesn’t read the field... hopefully that made sense?

@SimpleExcelVBA 3 жыл бұрын

Have You tried this use loop to read the sap table values? simpleexcelvba.com/how-to-deal-with-sap-tables-part-1/

@M4KE4W1SH 3 жыл бұрын

@@SimpleExcelVBA I haven’t, but I think that’s right along the lines of what I’m after!

@M4KE4W1SH 3 жыл бұрын

So I think I know why I’m having trouble. The session.findbyId on my table doesn’t end with “shell” like yours does. And when I open my order, everything is blue in the table area, which I believe makes it so I don’t have the Children-ColumnOrder Item values in my watch window.

@M4KE4W1SH 3 жыл бұрын

Any thoughts?

@SimpleExcelVBA 3 жыл бұрын

@@M4KE4W1SH Please send your code via email with the description and we will see what is going on :)

@trainingkods 3 жыл бұрын

Hello, I have a problem: Line "Set SapGuiAuto = GetObject("SAPGUI")" Sintaxe Error

@SimpleExcelVBA 3 жыл бұрын

Hello, try ("SAPGUI ") - with space or contact me directly & send me whole code :)

@walfreddeb9176 3 жыл бұрын

I have a question what is your mail adrrs

@SimpleExcelVBA 3 жыл бұрын

All contact info You can find on the simpleexcelvba.com/ in the About me or Contact me tab :)

@yadneshluste7751 3 жыл бұрын

Hi neeed your help

@SimpleExcelVBA 3 жыл бұрын

What is the issue? :)

@yadneshluste7751 3 жыл бұрын

@@SimpleExcelVBA I have recorded a sap script as I put my document number it shows multiple rows some time 2 or 1 or 3 but I want to select whichever is the last row every time

@yadneshluste7751 3 жыл бұрын

@@SimpleExcelVBA thank you so much for fast reply

@SimpleExcelVBA 3 жыл бұрын

@@yadneshluste7751 Email me with all the code attempts and your trials. We'll figure out something :)