Web ADI Journal Upload With Excel 2010 Erroring with The code in this project must be updated for use on 64-bit systems

Symptoms:

Uploading Web ADI Journal fails with
Compile Error : The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the Ptrsafe attribute.

Cause:

64 Bit Version of Excel (MS Office) installed - this is not certified with Web ADI

Certification Matrix

Solution:

Web ADI is not compatible with the 64-bit version of Excel at least in part because of the issues in VBA.

Please refer to http://technet.microsoft.com/en-us/library/ee681792.aspx

The recommendations for which edition of Office 2010 to install are as follows:

If users in your organization depend on existing extensions to Office, such as ActiveX controls, third-party add-ins, in-house solutions built on previous versions of Office, or 32-bit versions of programs that interface directly with Office, we recommend that you install 32-bit Office 2010 (the default installation) on computers that are running both 32-bit and 64-bit supported Windows operating systems.

(This is what applies to yourselves as you are using third-party add-ins built on previous versions of Office)

To run Web ADI you will need to uninstall the 64-bit version of Excel (Office?) and reinstall as 32 bit.