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.
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
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.
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.
No comments:
Post a Comment