Compile error due to 64-bit version of Microsoft Excel
Overview
While DirectDebitsLink can run on Microsoft Excel 2003, 2007, 2010 and 2013, it requires the 32-bit version of those products to be installed. The main reason for this is that both the MYOB ODBC driver is 32-bit only.
Note that DirectDebitsLink can run on 64-bit machines, but Microsoft Office must be 32-bit. If you try to run DirectDebitsLink on a 64-bit version, you will receive a compile error when DirectDebitsLink first start.
Also note that Microsoft Excel 2003 and 2007 are only available as 32-bit versions and are not affected by this issue.
If you do have Microsoft Office installed as a 64-bit version, you will need to uninstall it and install the 32-bit version which is located on the same disk.
How to check the version of Microsoft Excel 2010
- Start Microsoft Excel;
- Click on the File button;
- Click on the Help entry in the list;
The full version number, including 32-bit or 64-bit version is listed on the right hand side of the screen.
How to check the version of Microsoft Excel 2013
- Start Microsoft Excel;
- Click on the File button;
- Click on the Account entry in the list;
- Click on the About Excel button;
The full version number, including 32-bit or 64-bit version is listed in the first line.