Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Excel 2010: Where It Came From
Figure 1-4: Excel 4 was another significant step forward, although still far from Excel 5.
(Photo courtesy of Microsoft)
VBA is born
Excel 5 hit the streets in early 1994 and immediately earned rave reviews. Like its predecessor, it
finished at the top of every spreadsheet comparison published in the leading trade magazines.
Despite stiff competition from 1-2-3 Release 5 for Windows and Quattro Pro for Windows 5 —
both were fine products that could handle just about any spreadsheet task thrown their way —
Excel 5 continued to rule the roost. This version, by the way, was the first to feature VBA.
Excel 95 (also known as Excel 7) was released concurrently with Microsoft Windows 95.
(Microsoft skipped over Version 6 to make the version numbers consistent across its Office
products.) On the surface, Excel 95 didn’t appear to be much different from Excel 5. Much of the core
code was rewritten, however, and speed improvements were apparent in many areas.
Importantly, Excel 95 used the same file format as Excel 5, which is the first time that an Excel
upgrade didn’t use a new file format. This compatibility wasn’t perfect, however, because Excel
95 included a few enhancements in the VBA language. Consequently, it was possible to develop
an application using Excel 95 that would load but not run properly in Excel 5.