How to Find the Version of Excel with VBA Code
Press Alt + F11 to open the Microsoft Basic for Applications window. Copy and paste the below VBA code into the Module window, and then press the F5 key to run the code. Then a Microsoft Excel dialog box pops up with the version number displaying.
This of course begs the query “How do I know what version of Excel I am running?”
For more information, click on About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Click on the Excel tab from the menu on top of your screen.
How do I find what edition of Excel Am I using?
This article discusses how to find what edition of Microsoft Excel you are using. Select the File tab from the Excel ribbon and then select Account > About Excel. The version and bit-level of Excel will be displayed in the top line of the window: Your version and bit-level of Excel will appear under About Microsoft Excel.
Under Product Information, you’ll find your Excel version name and, in some cases, the full version number. For more information, click on About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Click on the Excel tab from the menu on top of your screen.
Find the version of Excel 2007. In the Excel Options dialog box, click Resources in left pane, then you can see the Excel version in the about Microsoft Office Excel 2007 section.
Another popular inquiry is “How to find Excel version with VBA code?”.
Besides the above methods, you can also find Excel version with VBA code. Press Alt + F11 to open the Microsoft Basic for Applications window.
How to check Microsoft Excel version and build number on Mac?
Click on Excel on the Mac Menu Bar and then select About Microsoft Excel. In the About Excel dialog box, all details will be displayed! So, you can either look at the starting screen of the application, the menu ribbon, or the help/about option in Excel to get information like product version, build number, etc.
How do I find the bit version of an Excel file?
For more information, such as the bit-version, choose About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Open any Office application, such as Word and create a new document.