Error: RE API support not installed - when using Office 2016 VBA after upgrading to 7.96

Users report after upgrading from 7.93 to 7.96 the RE API being used via Excel VBA is returning errors:

"RE API support not installed" 
Click OK and receive another message: "Run-time error '-2147024770 (8007007e)': Automation error The specified module could not be found" 
Click OK and see another error: "Run-time error '91': Object variable or With block variable not set"
These errors can be returned when Raiser's Edge is not open and running. Users should note that the VBA and API applications require Raiser's Edge to be running while in use.

If Raiser's Edge is running when these errors are returned, register bbcor7.dll to resolve the issue. The default file path for this file is C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\DLL\bbcor7.dll. For more information, see How to manually register a DLL or OCX file

Steps to Duplicate

  1. With a workstation with RE 7.93 (any patch), Open Excel 2016 and enable Developer on the Ribbon
  2. In the Excel document: Developer > View Code or click Visual Basic
  3. Tools > References > add a reference to "Blackbaud Raisers Edge 7 Objects"
  4. Add the following sample code (adjust for databases other than the RE sample if needed):
    Public Sub VBATest1()
        Dim oAPI As REAPI
        Set oAPI = New REAPI
        oAPI.Init "WRE1111", "", "", 50, , amStandalone
        MsgBox oAPI.SessionContext.CurrentUserID
        Set oAPI = Nothing
    End Sub
  5. Run this sub and verify that a connection to the API is made and the current user number appears in a pop-up message box.
  6. Save the Excel 2016
  7. Upgrade The Raiser's Edge to 7.96
  8. Attempt running the same sub in Excel.  The following errors appear in-order after clicking OK on each:
    1. RE API support not installed
    2. Run-time error '-2147024770 (8007007e)': Automation error The specified module could not be found
    3. Run-time error '91': Object variable or With block variable not set

Current workaround is to use an older version of Office/Excel.  For instance, this is not seen with Excel 2010.
 

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.