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.