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?
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.
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?
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. :)
@@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
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](http://i.ytimg.com/vi/8nvCW-l2Jdc/mqdefault.jpg)
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
Do you do 1on1 tutorial?
@@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.
Can we use this in any other tool??vba scripting?
Yes You can! :)
Thank you so much for sharing this valuable infos
You're welcome!
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?
Have You tried this use loop to read the sap table values?
simpleexcelvba.com/how-to-deal-with-sap-tables-part-1/
@@SimpleExcelVBA I haven’t, but I think that’s right along the lines of what I’m after!
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.
Any thoughts?
@@M4KE4W1SH Please send your code via email with the description and we will see what is going on :)
Great video, Is it necessary to activate some reference in excel so that it recognizes the sap objects?
No, it is not necessary :)
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?
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. :)
Can you use script recording in a purchase order for hundreds of items or same items ? Instead of line by line?
Record script, edit it, put the data from the table, loop it, that's all :)
Hello, I have a problem: Line "Set SapGuiAuto = GetObject("SAPGUI")" Sintaxe Error
Hello, try ("SAPGUI ") - with space or contact me directly & send me whole code :)
Hi man, could you make a video about how to connect and run script from excel to SAP when it already login
I will do that for sure! :)
I have a question what is your mail adrrs
All contact info You can find on the simpleexcelvba.com/ in the About me or Contact me tab :)
Hi neeed your help
What is the issue? :)
@@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
@@SimpleExcelVBA thank you so much for fast reply
@@yadneshluste7751 Email me with all the code attempts and your trials. We'll figure out something :)