The changes described in this article apply only to the 64-bit versions of Office. Visual Basic for Applications 7.0 (VBA 7) is released in the 64-bit versions for Office, and it works with both 32-bit and 64-bit applications. However, when you write 64-bit code, you should ensure that your code contains specific keywords and conditional compilation constants to ensure that the code is backward compatible with earlier version of Office, and that the correct code is being executed if you mix 32-bit and 64-bit code. When writing 32-bit code, you can use the 64-bit version of Office without any changes. The 64-bit versions of Office enable you to move more data around for increased capability, for example when you work with large numbers in Microsoft Excel 2010. Office applications are available in 32-bit and 64-bit versions. Find out how the 32-bit version of Office is compatible with the 64-bit version of Office.
