Excel screen updating false

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.



  1. Pingback:

  2. eric   •  

    “This young man saved my life and 5 others including a 16 year old girl that had been waiting for a heart transplant for many years,” she wrote.

  3. eric   •  

    Olive wants to give him what he deserves; after all, he really is a good, nice man…with a big dick.

  4. eric   •  

    It's disheartening how many women have to resort to 'please no sex pests' appendixs on their profile information.

  5. eric   •  

    Traversing the first 100 years of commercial photography, we’ve looked at daguerreotypes, collodion positives (aka ambrotypes), ferrotypes (aka tintypes), cartes de visite and cabinet cards, and now we turn to postcards—the most popular format for commercial photographers from 1900 to the 1950s.

  6. eric   •  

    If you have family ties to Asia, or are just a fan of Asian culture, this dating app can help put you in touch with matches that are perfect for you.

  7. eric   •  

    The couple are now proud parents of one-month-old daughter Bodhi and the 29-year-old actress has revealed the 'Vampire...

  8. eric   •  

    I use mine for all my sites all 27, they all get processed by the same account. Then when that process is over and you grab the IPN values with your listener, at that point the paypal process is over, they could care less after that.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>