Datasheet

21
Chapter 1: What Is VBA?
✓ Excel 4: This version hit the streets in early 1992. It also uses the XLM
macro language. A small number of people still use this version. (They
subscribe to the philosophy if it ain’t broke, don’t fix it.)
✓ Excel 5: This one came out in early 1994. It was the first version to use
VBA (but it also supports XLM). Excel 5 users are becoming increasingly
rare.
✓ Excel 95: Technically known as Excel 7 (there is no Excel 6), this version
began shipping in the summer of 1995. It’s a 32-bit version and requires
Windows 95 or Windows NT. It has a few VBA enhancements, and it sup-
ports the XLM language.
✓ Excel 97: This version (also known as Excel 8) was born in January,
1997. It has many enhancements and it features an entirely new inter-
face for programming VBA macros. Excel 97 also uses a new file format
(which previous Excel versions cannot open). Occasionally, I run into
someone who still uses this version.
✓ Excel 2000: This version’s numbering scheme jumped to four digits.
Excel 2000 (also known as Excel 9) made its public debut in June 1999.
It includes only a few enhancements from a programmer’s perspective,
with most enhancements being for users — particularly online users.
With Excel 2000 came the option to digitally sign macros, thus enabling
you to guarantee that the code delivered to your users is truly yours.
Excel 2000 still has a modest number of users.
✓ Excel 2002: This version (also known as Excel 10 or Excel XP) appeared
in late 2001. Perhaps this version’s most significant feature is the ability
to recover your work when Excel crashes. This is also the first version
to use copy protection (known as product activation).
✓ Excel 2003: Of all the Excel upgrades I’ve ever seen (and I’ve seen them
all), Excel 2003 has the fewest new features. In other words, most hard-
core Excel users (including yours truly) were very disappointed with
Excel 2003. Yet people still bought it. I think these were the folks moving
up from a pre-Excel 2002 version. As I write this, Excel 2003 is probably
the most commonly used version.
✓ Excel 2007: Excel 2007 signaled the beginning of a new era. Excel 2007
dumped the old menu and toolbar interface and introduced the Ribbon.
It also allows much larger worksheets — more than a million rows.
✓ Excel 2010: The latest, and without a doubt, the greatest. Microsoft
outdid its corporate self with this version. This version has some slick
new features (such as sparkline graphics), and it also performs quite a
bit better in some areas. And if you need really, really huge workbooks,
you can install the 64-bit version.
05_503690-ch01.indd 2105_503690-ch01.indd 21 4/12/10 11:22 PM4/12/10 11:22 PM