Microsoft Excel 5 0

Microsoft Excel 5 0

Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Active window capture. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.
Cached
WinWorld: Microsoft Excel 5.x
Microsoft Excel 5.0 For Windows (In - Computer Training ..
Microsoft Excel New Version
VERSIONRELEASEDDESCRIPTION
11985Version 1, for the Macintosh was released. There never was an Excel 1.0 for DOS or Windows.
21987Excel 2.0 is the first version of Excel for Intel platform.
31990Included Toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.
41992The first 'popular' version. Included lots of usability features.
51993A major upgrade. Included multi-sheet workbooks. Visual Basic for Applications (VBA) was introduced in this version.
71995Known as Excel 95. The first major 32-bit version of Excel. This is the first major version after Excel 5.0, as there is no Excel 6.0. Almost no external changes, but faster and more stable.
81997Known as Excel 97. A new interface for VBA developers, UserForms, Data Validation, and lots more.
This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels.
92000Included in Microsoft Office 2000. What is an external hard drive. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.Can use HTML as a native file format, 'self-repair' capability, pivot charts, modeless user forms.
102002Known as Excel 2002. Included in Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes.
This version features product activation technology. Please consider the ramifications of this before deciding whether to upgrade. 
112003Known as Microsoft Office Excel 2003. The new features in this version are:
Improved support for XML
A new 'list range' feature. Most significant feature in this version
Smart Tag enhancements
Corrected statistical functions.
Most users will not find the upgrade worthwhile.
122007Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being 'somewhat more negative' than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are:
New Ribbon menu System. This was a major upgrade.
SmartArt set of editable business diagrams.
Improved management of named variables through the Name Manager
Much improved flexibility in formatting graphs, which allow (x, y) coordinate labeling and lines of arbitrary weight.
Several improvements to pivot tables were introduced.
Office Open XML file formats were introduced, including .xlsm for a workbook with macros and .xlsx for a workbook without macros.
Specifically, many of the size limitations of previous versions were greatly increased. To illustrate, the number of rows was now 1,048,576 and columns was 16,384. This changes what is a valid A1 reference versus a named range.
This version made more extensive use of multiple cores for the calculation of spreadsheets; however, VBA macros are not handled in parallel and XLL add‑ins were only executed in parallel if they were thread-safe and this was indicated at registration. 
142010Included in Microsoft Office 2010, this is the next major version after version 12, as version number 13 was skipped.
Minor enhancements and 64-bit support, including the following features:
Multi-threading recalculation (MTR) for commonly used functions
Improved pivot tables
Pivot Table Slicers
More conditional formatting options
Additional image editing capabilities
In-cell charts called sparklines
Ability to preview before pasting
Office 2010 backstage feature for document-related tasks
Ability to customize the Ribbon
Many new Function, most highly specialized to improve accuracy 
152013Included in Microsoft Office 2013, along with a lot of new tools included in this release:
Improved Multi-threading and Memory Contention
FlashFill
Power View
PowerPivot Add-In
Timeline Slicer
Slicer with Excel Tables
Ability to Save files in OneDrive
Windows App
Inquire Add-In
Charting Enhancements
Recommended Charts and Pivot Tables
50 new functions
-->What's new in XLTools Add-In for Microsoft Excel 5.3.1: Added a new shortcut to Recalculate Range. Simply press Alt+F9 to recalculate formulas only in a selected range. Microsoft Excel 5.0 for Windows: Standard Course Cable, Sandra on Amazon.com.FREE. shipping on qualifying offers. Microsoft Excel 5.0 for Windows: Standard Course.
Represents a Microsoft Excel workbook.
RemarksThe Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.
CachedThe ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. In most cases, this is the same as the active workbook. However, if the Visual Basic code is part of an add-in, the ThisWorkbook property won't return the active workbook. In this case, the active workbook is the workbook calling the add-in, whereas the ThisWorkbook property returns the add-in workbook.
If you are creating an add-in from your Visual Basic code, you should use the ThisWorkbook property to qualify any statement that must be run on the workbook that you compile into the add-in.
ExampleUse Workbooks (index), where index is the workbook name or index number, to return a single Workbook object. The following example activates workbook one.
The index number denotes the order in which the workbooks were opened or created. Workbooks(1) is the first workbook created, and Workbooks(Workbooks.Count) is the last one created. Activating a workbook doesn't change its index number. Apk premiere pro cc. All workbooks are included in the index count, even if they are hidden.

The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name.
The following example activates Sheet1 in the workbook named Cogs.xls (the workbook must already be open in Microsoft Excel).

VERSION	RELEASED	DESCRIPTION
1	1985	Version 1, for the Macintosh was released. There never was an Excel 1.0 for DOS or Windows.
2	1987	Excel 2.0 is the first version of Excel for Intel platform.
3	1990	Included Toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.
4	1992	The first 'popular' version. Included lots of usability features.
5	1993	A major upgrade. Included multi-sheet workbooks. Visual Basic for Applications (VBA) was introduced in this version.
7	1995	Known as Excel 95. The first major 32-bit version of Excel. This is the first major version after Excel 5.0, as there is no Excel 6.0. Almost no external changes, but faster and more stable.
8	1997	Known as Excel 97. A new interface for VBA developers, UserForms, Data Validation, and lots more. This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels.
9	2000	Included in Microsoft Office 2000. What is an external hard drive. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.Can use HTML as a native file format, 'self-repair' capability, pivot charts, modeless user forms.
10	2002	Known as Excel 2002. Included in Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes. This version features product activation technology. Please consider the ramifications of this before deciding whether to upgrade.
11	2003	Known as Microsoft Office Excel 2003. The new features in this version are: Improved support for XML A new 'list range' feature. Most significant feature in this version Smart Tag enhancements Corrected statistical functions. Most users will not find the upgrade worthwhile.
12	2007	Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being 'somewhat more negative' than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are: New Ribbon menu System. This was a major upgrade. SmartArt set of editable business diagrams. Improved management of named variables through the Name Manager Much improved flexibility in formatting graphs, which allow (x, y) coordinate labeling and lines of arbitrary weight. Several improvements to pivot tables were introduced. Office Open XML file formats were introduced, including .xlsm for a workbook with macros and .xlsx for a workbook without macros. Specifically, many of the size limitations of previous versions were greatly increased. To illustrate, the number of rows was now 1,048,576 and columns was 16,384. This changes what is a valid A1 reference versus a named range. This version made more extensive use of multiple cores for the calculation of spreadsheets; however, VBA macros are not handled in parallel and XLL add‑ins were only executed in parallel if they were thread-safe and this was indicated at registration.
14	2010	Included in Microsoft Office 2010, this is the next major version after version 12, as version number 13 was skipped. Minor enhancements and 64-bit support, including the following features: Multi-threading recalculation (MTR) for commonly used functions Improved pivot tables Pivot Table Slicers More conditional formatting options Additional image editing capabilities In-cell charts called sparklines Ability to preview before pasting Office 2010 backstage feature for document-related tasks Ability to customize the Ribbon Many new Function, most highly specialized to improve accuracy
15	2013	Included in Microsoft Office 2013, along with a lot of new tools included in this release: Improved Multi-threading and Memory Contention FlashFill Power View PowerPivot Add-In Timeline Slicer Slicer with Excel Tables Ability to Save files in OneDrive Windows App Inquire Add-In Charting Enhancements Recommended Charts and Pivot Tables 50 new functions

The ActiveWorkbook property of the Application object returns the workbook that's currently active. The following example sets the name of the author for the active workbook.

This example emails a worksheet tab from the active workbook by using a specified email address and subject. To run this code, the active worksheet must contain the email address in cell A1, the subject in cell B1, and the name of the worksheet to send in cell C1.
EventsMethodsWinWorld: Microsoft Excel 5.xPropertiesSee alsoMicrosoft Excel 5.0 For Windows (In - Computer Training ..Support and feedbackMicrosoft Excel New VersionHave questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.