Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: MS Excel Macros Benchmarking VBA Code in Excel Tutorial

One method to benchmark re-written code or debate 'quicker' methods is to use VBA's built-in timer.

Tutorial Details:

Automate Excel

If you are looking to benchmark re-written code or debate "quicker" methods in VBA you can use VBA's built-in timer. Setting a variable equal to the timer at the start of your code and subtracting this from the timer at the end will give you a good estimate of how long a piece of code takes to run.

Performance may be affected by other programs running or trying to run while you're macro is active, among other things.

It would take to write the word "test" to cell A1 on Sheet1 a half million times. It took 21 seconds on my machine.





 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
MS Excel Macros Benchmarking VBA Code in Excel Tutorial

View Tutorial:
MS Excel Macros Benchmarking VBA Code in Excel Tutorial

Related Tutorials:

Accelerate your Java apps! - JavaWorld - September 1998
Accelerate your Java apps! - JavaWorld - September 1998
 
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
 
Use the JVM Profiler Interface for accurate timing - JavaWorld
Use the JVM Profiler Interface for accurate timing - JavaWorld
 
Jato: The new kid on the open source block, Part 2 - JavaWorld April 2001
Jato: The new kid on the open source block, Part 2 - JavaWorld April 2001
 
Think small: Java on Compaq's iPAQ
Think small: Java on Compaq's iPAQ
 
J2ME devices: Real-world performance
J2ME devices: Real-world performance
 
My kingdom for a good timer!
My kingdom for a good timer!
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
Learn to speak Jamaican
Introducing Jamaica, a JVM macro assembler language Most Java programmers, at one time or another, have wondered how the JVM works. Java bytecode programming reveals much insight into the JVM and helps developers program Java better. Also, the ability t
 
Jappo - an open and modular Java preprocessor
Jappo - an open and modular Java preprocessor Jappo is Java preprocessor. It examines input files for preprocessor statements (i.e. macros) that are then interpreted, resulting in the alteration of the input content that is stored as target file. Jappo
 
OpenSign
OpenSign OpenSign is a java applet for signing text in a webbrowser using a PKCS-12 key-files or keys located in MS Crypto API CSP's in a Win32 environment. The applet is based on code kindly provided by IT-Practice and everyone is encouraged to subm
 
The HTML Renderer Shootout, Part 1
The HTML Renderer Shootout, Part 1 In this article, we will review 11 different HTML renderers, comparing their features, compliance, and speed; searching for the best one for any project.
 
They just work
Writing CSV files: CSVPrinter This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
 
Servlet Essentials
This document explains the concepts of Java Servlets and provides a step-by-step tutorial for writing HTTP Servlets with complete source code for the example Servlets. The tutorial and the other chapters cover all facets of Servlet programming from a ...
 
JavaRSS.com 2004: Review of the Year
A look back at the major events of 2004 in Java.
 
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
 
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us.
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us. SuSe 9.1 Personal Linux Now Available SuSe 9.1 Personal CD's SuSE 9.1 Personal Edition was based on the x86 port of the Personal Edition, and it includes all of
 
Building Search Engine Applications Using Servlets !
Building Search Engine Applications Using Servlets ! Building Search Engine Applications Using Servlets Please visit http://www.webappcabaret.com/javadevelopers/search to see running copy of our search engine. Introduction This tutorial takes
 
Sun Java Desktop System Now Supports Solaris 10 OS
Sun Java Desktop System, Release 3 is now available on the Solaris 10 OS, along with management tools and some free and trial development tools.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.