Excel developers can use the command 'Application.Version' to get the version of Excel.
However, the new Excel 2019 returns the same version number as Excel 2016 (16.0).
We expected Excel 2019 to return the number 17.0 (or 19.0) but certainly not 16.0.
However, the new Excel 2019 returns the same version number as Excel 2016 (16.0).
We expected Excel 2019 to return the number 17.0 (or 19.0) but certainly not 16.0.
- Microsoft Excel 2019 16 34 Months Ago
- Purchase Microsoft Excel 2019
- Microsoft Excel 2019 16 34 Months 15
We recently purchased and installed the new Office 2019 in order to (successfully) test ASAP Utilities with it.
To our surprise, we noticed that the new Excel 2019 internally still shows the number 16 as the version and not a higher number such as 17 or 19.
The command 'Application.Version', returns 16,0 for both Excel 2016 and the new Excel 2019.
And the command 'Application.Build', also returns the exact same number when the latest updates are installed.
Upon further research, we noticed that the detailed version numbers, via 'File > Account > About Excel' are also exactly the same for Excel 2016 and 2019:
To our surprise, we noticed that the new Excel 2019 internally still shows the number 16 as the version and not a higher number such as 17 or 19.
The command 'Application.Version', returns 16,0 for both Excel 2016 and the new Excel 2019.
And the command 'Application.Build', also returns the exact same number when the latest updates are installed.
Upon further research, we noticed that the detailed version numbers, via 'File > Account > About Excel' are also exactly the same for Excel 2016 and 2019:
Excel for insightful spreadsheets – anytime, anywhere and with anyone. A modern take on Excel with new built-in tools help you get more out of your data. Create your best work with Microsoft 365. By Martin Brinkmann on August 16, 2019 in Microsoft - Last Update: August 16, 2019 - 61 comments The latest version of Microsoft Office for the desktop is Office 2019; the company released Office 2019 in September 2018 and made it a Windows 10 exclusive which means that it supports it only on devices running Windows 10 and latest Windows Server. Working with a spaced series in Excel 2019 AutoFill uses the initial value that you select (date, time, day, year, and so on) to design the series. All the sample series shown above change by a factor of one (one day, one month, or one number).
Excel 2019 with latest updates on October 5th, 2018 shows: 16.0.10827.20118
Adobe lightroom classic 9 2 iso.
Adobe lightroom classic 9 2 iso.
Excel 2016 with latest updates on October 5th, 2018 shows 16.0.10827.20118:
Via File > Account, Office 2019, shows:
Version 1809 (Build 10827.20138 Click-to-Run)
Version 1809 (Build 10827.20138 Click-to-Run)
Via File > Account, Office 2016, shows the exact same version as Office 2019:
Version 1809 (Build 10827.20138 Click-to-Run)
Version 1809 (Build 10827.20138 Click-to-Run)
In the 'Programs and Features' section in the Windows Control Panel, the version number of Office 2019 is also 16.0..
Has Microsoft forgotten to update the internal version number in Excel 2019?
Based on the detailed version numbers (16.0.10827.20118), it seems as if Excel 2016 with the latest updates is exactly the same as the new launched Excel 2019. Although we did notice that Excel 2016 with the latest updates is missing some features that are new in Excel 2019, such as funnel charts.
This makes us wonder if Microsoft has forgotten to update the internal version number of Excel from 16.0 to 17.0?
Microsoft Excel 2019 16 34 Months Ago
Update January 17, 2020; Microsoft: The major version of Office 2019 is staying at 16.0
We now know officially that Microsoft decided to keep the major Excel version number for Excel 2019 the same as for Excel 2016 on purpose (which I still find a strange decision).
Microsoft: The major version of Office 2019 is staying at 16.0, so some additional things are staying the same for those upgrading from Office 2016, including the following:
![Microsoft Excel 2019 16 34 Months Microsoft Excel 2019 16 34 Months](https://calendartomap.com/wp-content/uploads/2019/01/2019-Calendrier-France.jpg)
- Existing Group Policy settings will continue to work, because the registry location for those settings will still be located in HKEY_LOCAL_MACHINESOFTWAREPoliciesMicrosoftOffice16.0 and HKEY_CURRENT_USERSOFTWAREPoliciesMicrosoftOffice16.0.
- Other registry locations and settings information that reference 16.0 will still apply.
- Add-ins and other extensibility solutions that are compatible with Office 2016 will most likely be compatible with Office 2019 or will require only minimal testing.
Source: https://docs.microsoft.com/en-us/deployoffice/office2019/overview
You may also like:
Filed under: ASAP Utilities, General on October 5th, 2018 by Bastien | 3 Comments »
-->Note
Purchase Microsoft Excel 2019
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Summary
This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that prompts you for the month and year and creates a monthly calendar using a worksheet.
Resolution
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
To create the calendar, follow these steps.
Microsoft Excel 2003
- Create a new workbook.
- On the Tools menu, point to Macro, and then click Visual Basic Editor.
- On the Insert menu, click Module.
- Copy the Visual Basic for Applications code below into the module sheet.
- On the File menu, click 'Close and Return to Microsoft Excel.'
- Click the Sheet1 tab.
- On the Tools menu, point to Macro, and then click Macros.
- Click CalendarMaker, and then click Run to create the calendar.
Microsoft Excel 2019 16 34 Months 15
Microsoft Excel 2007 or later
- Create a new workbook.
- On the Developer ribbon, Click Visual Basic.
- On the Insert menu, click Module.
- Copy the Visual Basic for Applications code below into the module sheet.
- On the File menu, click 'Close and Return to Microsoft Excel.'
- Click the Sheet1 tab.
- On the Developer ribbon, click Macros
- Click CalendarMaker, and then click Run to create the calendar.
Note Moom 3 2 11.
If the Developer Ribbon is not showing go to Excel Options and enable it. In Excel 2007 you will find it in the Popular menu and in Excel 2010 you will find it in the Customize Ribbon menu.
Sample Visual Basic Procedure
You can add other code to customize the calendar to meet your needs. Insert extra rows for entry on the screen for each day or resize the screen to see all of the calendar based on screen size and resolution.