Description

This error message is reported only when the user runs the GUI Scripts issue after updating Office 2016 v1806 (Build 10228.20080).

Applies To

Studio 

Excel builds 1806 and 1902

Cause

After updating Office 2016 v1806 (Build 10228.20080), the creation of the VBscript engine fails with: hr = CoCreateInstance(CLSID_VBScript, NULL, CLSCTX_INPROC_SERVER, IID_IActiveScript, (void**)&m_pActiveScript); hr: 0x80070005: Access is denied.

Solution

Add registry entry from installer from Office 2016 (Build 10228.20080) onwards.

To override and allow a OLE/OEM component, follow these steps:

Check OS version from Computer -  Properties
Office bit version from Excel, account - About Excel. Data seen in tiny header line.
 
 
Then based on your OS/ExcelVersion case, go to registry in path
Case 1 - 64/32 bit Office with 32 bit OS:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Common\COM Compatibility
Case 2 - 32 bit Office with 64 bit OS:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Common\COM Compatibility\
 
Add this key if it is not present
{B54F3741-5B07-11cf-A4B0-00AA004A55E8}
This key is for enabling VBScript in Excel.
(Program related can be seen in registry Computer\HKEY_CLASSES_ROOT\CLSID\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}\ProgID and it gives me VBScript. )
 
Then inside this key just added, add D-Word ActivationFilterOverride and modify its value to 1.
 

The file is no longer available.

Additional Information

If you had previously applied this fix and then upgraded Office again, please note that you will need to reapply the fix. 

Read more : https://support.microsoft.com/en-us/help/4032364/how-to-control-the-blocking-of-ole-com-components-in-microsoft-office

See also the attached resolution article