Run-Time Error 429 ActiveX Component Can't Create Object error when you click Test Connection in DCS 6.8 ReportTemplate-v6.8.xlsm

Products

• Data Center Security Monitoring Edition
• Data Center Security Server
• Data Center Security Server Advanced

Issue/Introduction

Using the ReportTemplat-v6.8.xlsm tool in order to work with the Data Center Security (DCS) 6.8 Managers API you receive a "Run-Time Error 429 ActiveX Component Can't Create Object" when you click Test Connection.

Run-Time Error 429 ActiveX Component Can't Create Object

Cause

Microsoft did not include the libraries from 32 bit versions of office for ScriptControl in 64 bit.

Environment

Windows 64 bit Operating System

64 bit Office 2016 or Newer

Resolution

You must use 32 bit Office 2016 or newer to use this tool.