Cannot create business layer objects in 64-bit MS Office VBA

TSB1033 | Thursday, 10 October 2013

This technical Support Bulletin applies to 64-bit machines with Microsoft Office.

Overview

If you are running 64-bit Office you will be able to use the business layer that is passed into the document. However, you will not be able to create a new business layer in VBA. For example, if you were running VBA from finPOWER the finPOWER business layer is passed to the VBA for use. If you then wanted to create an emPOWER business layer for back office integration you will not be able to.

Issue

32-bit ActiveX controls are not compatible with the 64-bit version of Office.

Solution

Revert to 32-bit version of office or ensure only using business layer objects passed into the document. In most cases there should not be an issue however some older templates may need to be reviewed for compatibility.