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.
- Buy Excel 2019
- Microsoft Excel 2019 16 34 Months Old
- Microsoft Excel 2019 16 34 Months 4
- Microsoft Excel 2019 Cd
- Microsoft Excel Office 2019
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 2019 with latest updates on October 5th, 2018 shows: 16.0.10827.20118
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)
Syntax: DATE(year,month,day) The DATE function syntax has the following arguments: Year Required. The value of the year argument can include one to four digits. Excel interprets the year argument according to the date system your computer is using. By default, Microsoft Excel for Windows uses the 1900 date system, which means the first date is. When the day arrives, Office 2016 installs will be barred from connecting to Microsoft’s cloud-based services, including Exchange and OneDrive. ESoftware Associates is a professional Microsoft Consulting firm specializing in SharePoint, Office 365, Excel, Office and SQL Server solutions and support.
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?
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). Shottyblur 1 1. Highland 1 8 9.
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:
- 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
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post. Starmoney 3 3.
Summary
Buy Excel 2019
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.
Microsoft Excel 2019 16 34 Months Old
Resolution
Microsoft Excel 2019 16 34 Months 4
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 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.
Microsoft Excel 2019 Cd
Note
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
Microsoft Excel Office 2019
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.