All videos in GUI scripting Playlist are professional, meaningful and really useful. All visitors can only be thankful for this knowledge shared only by good will.
Very good tutorial, i love how you used the watch window and the object browser to find the objects/properties/methods you needed to complete the task.
i'd like to thank you again. the whole playlist helped me a lot! please continue teaching about sap!! it's so complicated and yet you make it sound a lot easier... cheers!
"Object doesn't admit this property or method", in line For i = 0 To GridView.ColumnCount - 1 Cells(13, i + 1).Value = GridView.GetColumnTitles(GridView.ColumnOrder(i))(0) Next i Thanks for your videos
Awesome works Varga!. Thank you so much for your teaching. I you can make another video about SAP GUI Scripting - Download attachments from Display Document (FB03)
Csongor, very good video> Thanks a lot ! I have done it for the Tcode ZTB but the macro doesnt download the report till the last row. Do you know why ?
Yes, that is something I have not covered in this video. Sometimes when the GridControl has many items, SAP only reads some of the items up front, and it reads the rest when you start scrolling. I don't know from the top of my head the moment, but there is a scroll property you can set and simulate scrolling in the GridView. Best if you do it line by line to make sure the line are read by the GUI.
Thank you for this video, I created a lot of script for my team. I have a question, i can only extract 282 rows for this code. I am extracting data from ST22. I got 409 dumps but only 282 is extarted. How can i capture all the data?
Yes, the issue is that SAP loads these lists dynamically as you scroll. First get the max items of the view from RowCount, and create a loop where you update the FirstVisibleRow property. That will scroll the view and load the missing data. This is how I did it with a different transaction. Your view might have different attributes, but the idea is the same.
Hello Sir. Very thankfull for teaching how to combine the SAP GUI Scripting & VBA. It is very helpfull, and I think I´ll speak for everyone wathcing your Videos. Much more I would appreciate helping me with some VBA Code and combining two of your(Tutorials) Codes into one. Extracting the Datas Using the "Referenze Number" (Video Tut #4) and Pasting into the Excel Sheet is the first Step and it Works like a charm.The next Step i have to use some of the extracted data as a search condition in another SAP TCode and take/copy the data from the Grid View (but not the whole line, only 2 fields) in an anotehr transactions. I would appreciate your time by helping me. Thanks in advance.
Thanks for your comment. I am not sure which part you are missing, but the GridView has a GetCellValue method. You pass the line number and column name (technical name of the column) and you get the value.
Thank you. Using this for loop extracts all the data from the GridView. As Im not needing all the data, i have to extract only specific columns and rows. For i = 0 To GridView.ColumnCount - 1 For j = 0 To GridView.RowCount - 1 Cells(10 + j, i + 1).Value = GridView.GetCellValue(j, GridView.ColumnOrder(i)) Next j Next i In the GridView i have always 63 columns and 2 rows. I need (Row1 Column3) (Row1 Column37) & (Row2 Column3) (Row1 Column37) data to be extracted. What should be changed in the code? Thanks in advance for your time. Kind regards.
Something like that: Cells(11, 1).Value = GridView.GetCellValue(3, GridView.ColumnOrder.Item(0)) Cells(12, 1).Value = GridView.GetCellValue(37, GridView.ColumnOrder.Item(0)) Cells(13, 1).Value = GridView.GetCellValue(3, GridView.ColumnOrder.Item(1)) Cells(14, 1).Value = GridView.GetCellValue(37, GridView.ColumnOrder.Item(1)) This will extract these 4 values to A11, A12, A13, A14. Keep playing around with the numbers if it is off by a row or column.
How do I get SAPFEWSELib in my object browser library? Without it, I can't use the objects/properties/methods such as ".GetColumnTitles" or ".ColumnOrder"
it's very good, I did some scrips for MM01 and FB01, THANKS. You saved my life and my users too. now I'm trying to select all fields of the table by script. is this possible? Bye from Spain.
Hi, Good Morning. May I know how to export entire MARA/MARC table from SE16N grid view to excel? Recording stops soon after the 'Save As' dialog comes up. Is there any other methods to export using VBA/VBS-GUI Scripting?
You cannot record Save As. That is a Windows dialog box and SAP cannot script that. Enter the file name manually on the dialog box. That is the only way.
Thank you so much. You saved my browsing time. Was doing R&D on this since last few weeks. May be then I need to explore some other ways then.. using SAP standard features. Somehow I wanted to get rid of this manual task.
Good morning, Varga! Its content is of the highest value, congratulations. I'm trying to read a GridView Control from transaction MD04, but I'm not having success. the problem appears in: Set GridView = objSess.findById ("wnd [0] / usr / cntlGRID1 / shellcont / shell / shellcont [0] / shell") Would you know how to guide me? Thanks.
@@fabiob_1987 OK good. Are you sure that it the correct handle for the GridView you need? Did you get it from the watch window or was that generated by the script recording?
@@csongorvarga got by recording the script at the moment I don't know how to get this information by the watch window. would you know a way to get the correct handle for the Grid View from transaction MD04?
@@fabiob_1987 Well, if you record a script where you go into the screen where the Gridview is, click on the gridview and stop the recording the last line in the code should have the gridview handle.
It is an awesome solution., I managed to extract all the information I need
All videos in GUI scripting Playlist are professional, meaningful and really useful. All visitors can only be thankful for this knowledge shared only by good will.
Thanks a lot.
Very good tutorial, i love how you used the watch window and the object browser to find the objects/properties/methods you needed to complete the task.
i'd like to thank you again. the whole playlist helped me a lot! please continue teaching about sap!! it's so complicated and yet you make it sound a lot easier... cheers!
This video is old but it helped me a lot. Saved me my job. Thanks
Man, I was stuck in several development projects and this playlist set me free and took me to another level! THANK YOU, brother!!
You are welcome bro!
Excellent video. I especially like the way you used the watch window to find properties, and then tested them right in the watch window, Bravo!
Thanks a lot.
Great video! Thank you for sharing!
Just found this excellent tutorial. Great job thanks a lot. Can't wait to see more videos !!
really excellent, thank you so much for this sharing.
"Object doesn't admit this property or method", in line
For i = 0 To GridView.ColumnCount - 1
Cells(13, i + 1).Value = GridView.GetColumnTitles(GridView.ColumnOrder(i))(0)
Next i
Thanks for your videos
Thank you so much... very useful videos...
This is a gorgeous tutorial, thanks it will help me a lot!
Thanks this is very helpfull, please continue teaching about sap
can't thank you any more ！very useful !! save me a lot of time !! this is just what I need
Awesome works Varga!. Thank you so much for your teaching. I you can make another video about SAP GUI Scripting - Download attachments from Display Document (FB03)
Csongor, very good video> Thanks a lot ! I have done it for the Tcode ZTB but the macro doesnt download the report till the last row. Do you know why ?
Yes, that is something I have not covered in this video. Sometimes when the GridControl has many items, SAP only reads some of the items up front, and it reads the rest when you start scrolling. I don't know from the top of my head the moment, but there is a scroll property you can set and simulate scrolling in the GridView. Best if you do it line by line to make sure the line are read by the GUI.
Thank you for this video, I created a lot of script for my team.
I have a question, i can only extract 282 rows for this code.
I am extracting data from ST22. I got 409 dumps but only 282 is extarted. How can i capture all the data?
Yes, the issue is that SAP loads these lists dynamically as you scroll. First get the max items of the view from RowCount, and create a loop where you update the FirstVisibleRow property. That will scroll the view and load the missing data. This is how I did it with a different transaction. Your view might have different attributes, but the idea is the same.
@@csongorvarga Thank you! I was able to capture all information now.
Hello Sir. Very thankfull for teaching how to combine the SAP GUI Scripting & VBA. It is very helpfull, and I think I´ll speak for everyone wathcing your Videos. Much more I would appreciate helping me with some VBA Code and combining two of your(Tutorials) Codes into one. Extracting the Datas Using the "Referenze Number" (Video Tut #4) and Pasting into the Excel Sheet is the first Step and it Works like a charm.The next Step i have to use some of the extracted data as a search condition in another SAP TCode and take/copy the data from the Grid View (but not the whole line, only 2 fields) in an anotehr transactions. I would appreciate your time by helping me. Thanks in advance.
Thanks for your comment. I am not sure which part you are missing, but the GridView has a GetCellValue method. You pass the line number and column name (technical name of the column) and you get the value.
Thank you. Using this for loop extracts all the data from the GridView. As Im not needing all the data, i have to extract only specific columns and rows.
For i = 0 To GridView.ColumnCount - 1
For j = 0 To GridView.RowCount - 1
Cells(10 + j, i + 1).Value = GridView.GetCellValue(j, GridView.ColumnOrder(i))
Next j
Next i
In the GridView i have always 63 columns and 2 rows. I need (Row1 Column3) (Row1 Column37) & (Row2 Column3) (Row1 Column37) data to be extracted. What should be changed in the code? Thanks in advance for your time. Kind regards.
Something like that:
Cells(11, 1).Value = GridView.GetCellValue(3, GridView.ColumnOrder.Item(0))
Cells(12, 1).Value = GridView.GetCellValue(37, GridView.ColumnOrder.Item(0))
Cells(13, 1).Value = GridView.GetCellValue(3, GridView.ColumnOrder.Item(1))
Cells(14, 1).Value = GridView.GetCellValue(37, GridView.ColumnOrder.Item(1))
This will extract these 4 values to A11, A12, A13, A14. Keep playing around with the numbers if it is off by a row or column.
Thank you once again, but this is not working for me.
I need to verify a grid to check if there is a variant created and then select it
How can I use your example to check the value in the grid?
Great job! Thanks!
How do I get SAPFEWSELib in my object browser library? Without it, I can't use the objects/properties/methods such as ".GetColumnTitles" or ".ColumnOrder"
How to loop through cntlContainer ?
it's very good, I did some scrips for MM01 and FB01, THANKS.
You saved my life and my users too.
now I'm trying to select all fields of the table by script. is this possible?
Bye from Spain.
It depends, the GridView has a SelectAll method which should work. But if it is a different control, it may work in a different way.
How to adda row inside a grid view ?
Csongor excellent videos, it is possible to execute this from Microsoft access? if so, can you show us how? thank u!!
VintaGCR Must be, let me investigate.
Check the latest in the playlist. I just uploaded a new video: th-cam.com/video/pKAZqS_tEj4/w-d-xo.html
How do you find the SID+Client?
Hi, Good Morning. May I know how to export entire MARA/MARC table from SE16N grid view to excel? Recording stops soon after the 'Save As' dialog comes up. Is there any other methods to export using VBA/VBS-GUI Scripting?
You cannot record Save As. That is a Windows dialog box and SAP cannot script that. Enter the file name manually on the dialog box. That is the only way.
Thank you so much. You saved my browsing time. Was doing R&D on this since last few weeks. May be then I need to explore some other ways then.. using SAP standard features. Somehow I wanted to get rid of this manual task.
Great tutorial,, will this also work in VK13?
I don't have system access at the moment, but this should work with any gridviews. List type of data in SAP screen are usually use gridview.
Thanks for the reply
If you can, please do a macro tutorial using AL11. on How to download/export files to local drive. A big thanks
Good morning, Varga!
Its content is of the highest value, congratulations.
I'm trying to read a GridView Control from transaction MD04, but I'm not having success.
the problem appears in:
Set GridView = objSess.findById ("wnd [0] / usr / cntlGRID1 / shellcont / shell / shellcont [0] / shell")
Would you know how to guide me?
Thanks.
Thanks. Did you just put spaces in the ID for the comment? There should be none in your code.
@@csongorvarga is just in the comment. There's no spaces in the code
@@fabiob_1987 OK good. Are you sure that it the correct handle for the GridView you need? Did you get it from the watch window or was that generated by the script recording?
@@csongorvarga got by recording the script
at the moment I don't know how to get this information by the watch window.
would you know a way to get the correct handle for the Grid View from transaction MD04?
@@fabiob_1987 Well, if you record a script where you go into the screen where the Gridview is, click on the gridview and stop the recording the last line in the code should have the gridview handle.
The image quality is bad.
Rodrigo Luiz de Sordi What do you mean?
In the setup video you can select the quality, it is available in 1080p
Sorry. You're right. tks.
Sempre um brasileiro cagando