Hello, I'm using the above approach to connect to SAP in order to upload data from excel to SAP R/3 transaction.
Myquestions is there exist away to prevent the screen flickering from EXCEL to SAP during the macro processing , tried to the statement at the excel macro : Application. In other words my requirement is not see SAP screen at all during the macro processing.
This should certainly be the case as Excel doesn't have to continually redraw the screen each time something changes.
If we want to quantify how much time we've saved we can add some code to create a basic timer system.
The easiest way to achieve this to avoid selecting or activating objects such as worksheets and ranges as much as possible.
In the example code shown below the only time an object is selected is when a new worksheet is added to the workbook.
Alternatively, if you're feeling ambitious, you might consider using some Windows API functions to create incredibly accurate timers.
Screen updating is especially important for long-running macros (e.g.
You can achieve this by using the Screen Updating property of the Application object.