SAP GUI Scripting - Scripting from Access

This example shows how to execute a SAP GUI script from MS Access. It is using the extract of lock entries like in the last Excel example.

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

[julianmendoza]

Thanks Csongor, you've come to my rescue again - very useful transformation of the SAP GUI to excel extract query

[_sxmxt]

Hi !

Why the script takes only 84 rows from sap.. i need the complete table.. have anyone an idea how i can realize it

[tuananhlecong]

I like this method, but after scripting running about 100 row, all row after that always blank . I try to make it slowdown but nothing change. Can you have me pls!

[aldonova]

@Csongor Varga - thanks for this. I have a question about the grid view object. I am running a report in SAP that contains several thousand records and in the grid view of SAP, I have to page down to get to the end. When I execute the script in Access, I am only extracting a few hundred records. Is there a way to define the grid view object in the code so that it includes all the records in the SAP screen? I was thinking that because my grid view in SAP contained many records that were not visible until I scrolled down, that somehow that was causing Access to only extract the 'visible' records from SAP.

[hobsonjin]

Hi Varga, any idea about how to extract more than 8 millions records from one SAP table to a MS. access table?
Thanks in advance.

[jamesgilliam]

I like your work. I have to ask I am try to take the access and pull the data in se16. any is on the right path?

[whalebig]

Hi Csongor, Thanks your video. I got a error message "Object doesn't support this property or method" on the code: GirdView.GetCellValue, do you know why? I use Access2010.

[thiagogarrucho]

I have found the website erptrainingtech and it is working well, have you guys tried?