+ Reply to Thread
Results 1 to 4 of 4

Execution speed of macros

  1. #1
    Registered User
    Join Date
    06-23-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Execution speed of macros

    Hello all,
    My question is, is there any difference in the execution speed of the code in macros depending on how good the computer's processors are?

    For instance, would the code execute faster on a newer, more advanced computer, and thus execute more slowly on an older computer?


    Or is the rate of execution standard on all computers? For instance, if the newer computer and older computer can adequately handle the processing speed for the macros as required by excel, will the macros run at the same speed on both computers?

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Execution speed of macros

    There is a difference particularly with large data. You can run the same code and same data on two different PCs with different CPUs, include timing in both codes and see the result.

  3. #3
    Registered User
    Join Date
    06-23-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Execution speed of macros

    Yes, I was thinking of developing a function that runs a loop with an OnTime event at the start, for 1 second. Then I run a loop to a ridiculously high number containing the commands, and before the end of each loop a variable will increment once.
    When the 1 second event is up, then there will be a message box that says "your computer can execute this code (variable) amount of times."

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Execution speed of macros

    I was referring to a timer with a message box which could be included within a code and that could calculate the duration of a code to complete, so that you can compare the two PCs with different CPUs and other factors which affects the performance of a PC.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Execution Speed of VBA Code
    By sdelaney7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2012, 08:35 PM
  2. VBA Shift Rows Within Range - Execution Speed
    By eadamy in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-22-2011, 06:28 PM
  3. how to speed up macro code execution?
    By sharmanjali87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2010, 06:45 AM
  4. Speed up Excel execution
    By Sinus Log in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2005, 01:10 AM
  5. code execution speed question
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1