(Solved) – How can the speed of a SAP GUI VBA script be boosted? [closed]

(solved)-–-how-can-the-speed-of-a-sap-gui-vba-script-be-boosted?-[closed]

I am writing some SAP GUI VBA scripts. I have created a script to update entries in a SAP table based on values in an Excel file. The Excel file is just an extracted version of the SAP table with new dates.

The script gets the values from a record in Excel searches the SAP table with the same and then changes a specific value, in this case the End Date. The bottleneck here is that only one line can be processed at a time.

Does anyone know how to boost the speed here? As there lots of records needing to be updated, processing a line at a time is too slow for us.

Leave a Reply

Your email address will not be published. Required fields are marked *