Name

workbook.CalculationVersion

Synopsis

Returns a number representing the major and minor versions of Excel last used to recalculate the workbook. For example, the following code displays “114210” on my machine, where “11” is the major version of Excel (2003 is Version 11) and “4210” is the minor, or build version:

Debug.Print ThisWorkbook.CalculationVersion

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.