In these scenarios, your best option is to use one of the external functions that are embedded in dynamic linked library (DLL) files.

You do this in VBA by making API calls using attribute.

To resolve this, VBA now contains a true statements to work as they always have.

It is important to note that the changes addressed in this article apply only to the 64-bit version of Microsoft Office 2010.

Using the 32-bit version of Office 2010 enables you to use solutions built in previous versions of Microsoft Office without modification. Additionally, you must update address pointers and display window handles in user-defined types that are used by these statements.

For Active X controls and COM objects, there are three possible solutions: (Animation, Up Down, Month View, Date Time Picker, Flat Scroll Bar).

These controls were installed by previous versions of Microsoft Office and are installed by 32-bit Office 2010.

This is discussed in more detail in this article as well as compatibility issues between the 32-bit and 64-bit versions of Office 2010 and suggested solutions.

Applications built with the 64-bit version of Office 2010 can reference larger address spaces, and therefore provide the opportunity to use more physical memory than ever, potentially reducing the overhead spent moving data in and out of physical memory.The combination of VBA and type libraries gives you lots of functionality to create Microsoft Office applications.However, sometimes you must communicate directly with the computer’s operating system and other components such as when you manage memory or processes, when working with the user interface such as windows and controls, or when modifying the Windows registry.(7 Printed Pages) In this article Introducing the 32-bit and 64-bit Versions of Microsoft Office 2010 Comparing 32-Bit Systems to 64-Bit Systems Introducing the VBA 7 Code Base Active X Control and COM Add-in Compatibility Application Programming Interface Compatibility Using Conditional Compilation Attributes Frequently Asked Questions Conclusion Additional Resources Published: March 2010 Provided by: Microsoft Corporation Contents The Microsoft Office 2010 system is available in both 32-bit and 64-bit versions.The 64-bit version enables you to work with much larger sets of data.constant (this is the more typical case) to prevent 64-bit code from being used in the earlier version of Microsoft Office.