How to Check Whether Microsoft Office VBA Is 32-Bit or 64-Bit
Question details
Determine whether Microsoft Office VBA is running as a 32-bit or 64-bit version.

- Product
- Microsoft Office VBA
- Device & OS
- not provided
- Scenario
- The user needs to check Office bitness, potentially to choose a compatible VBA solution or switch Office versions.
- Observed behavior
- VBA uses the bitness of the installed Office version, which may differ from the operating system's bitness.
Open an installed Microsoft Office application such as Excel or Word. Check the Office version itself rather than relying on the Windows system information.
Check Office bitness in the About dialog
Use the application’s account information to identify the bitness used by Office VBA.
Launch Microsoft Excel or Word and open a blank document or workbook.
Select File > Account, then choose About Excel or About Word.
Look at the version information in the About dialog for “32-bit” or “64-bit.” VBA uses the same bitness as the installed Office application.

Reinstall Microsoft Office with the required bitness
Use this approach if you need to change from 32-bit to 64-bit Office or vice versa.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Open existing files to make moving between suites straightforward. WPS does not change or identify the bitness of your Microsoft Office installation, and VBA compatibility may vary.

Frequently Asked Questions
Does 64-bit Windows mean I have 64-bit Office VBA?
No. Windows can run 32-bit Office, and VBA follows Office bitness. In Excel or Word, select File > Account > About to check the installed version.
Where can I find the bitness in Excel?
Open Excel and select File > Account > About Excel. The version information in the dialog identifies Excel as 32-bit or 64-bit.
Is switching from 32-bit to 64-bit Office free?
A separate purchase may not be necessary if your existing Office license includes the version you need. Sign in to the Microsoft account associated with Office and check the available installation options.
Will reinstalling Office delete my documents?
Uninstalling Office normally does not delete personal documents or the normal template. After reinstalling, open your files from their existing locations and check that any add-ins and VBA code work with the new bitness.




