Remediation of VBA Code That Runs Under 64-bit MS Office Print E-mail
Windows 64-bit
Written by Darwin Sanoy   
Friday, October 5, 2012 12:00am
Just like Microsoft, our strong advice on what edition of Office 2010 to run is "32-bit"! The simple reason is that vast majority of the thousands of MS Office plug-ins are only available in 32-bit versions and probably will be for some time to come. On top of this reason is the need to evaluate all your VBA code to see if it needs some minor modifications to run on 64-bit. If you are planning on running 64-bit office, read on for links to help you ensure the compatibility of your existing VBA code (whether written by you or part of a third-party plug-in).

Since we expect that it is a small minority of businesses that choose to try to run 64-bit MS Office, I'm just going to post some excellent Microsoft links on the issues and a tool to help you.

Microsoft talks about the overall issues in: Working with VBA in Office 2010 (32-bit) and Office 2010 (64-bit) and in Compatibility Between the 32-bit and 64-bit Versions of Office 2010

Here is the usage guide on the Office Compatibility Code Inspector

Here is where you can Download the Office Compatibility Code Inspector