There is a good white paper available that gives you invaluable information about 64-bit Office. Here are the download link,
Office Enterprise 2007 Key, description,
Office Professional 2007, and table of contents. Compatibility Between the 32-bit and 64-bit Versions of Office 2010 Summary: For customers working with large amounts of data,
Microsoft Office Professional Plus 2007 Key, Microsoft Office 2010 is now available in a 64-bit version. This article discusses issues around the compatibility of the 32-bit version with the new 64-bit version and legacy 32-bit Office applications and their solutions. (12 Printed Pages) 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
ActiveX Control and COM Add-in Compatibility
Application Programming Interface Compatibility
Using Conditional Compilation Attributes
Conclusion
Additional Resources <div