Microsoft’s April Security Updates Kill VBA ScriptsIssue:Several of the recent Microsoft Security Updates for April have introduced a problem with executing VBA scripts in Bentley Structural Modeler XM & V8i, Bentley Structural Modeler XM & V8i and AECOsim Building Designer V8i. The issue may also be prevalent in other Bentley applications that use VBA scripts. The Microsoft Security Updates may affect Bentley applications on both Window XP and 7 clients.Symptoms:The symptoms that you have been affected by one of these Microsoft Security Updates is you may receive one of several variations of a VBA error in the message center of Bentley Structural Modeler XM & V8i, Bentley Structural Modeler XM & V8i, AECOsim Building Designer V8i or other Bentley applications. Error messages include but are not limited to:• VBA interface error: unable to run macro - invalid procedure name (error when placing Structural joist girder / bar joist / analysis Import/export)• VBA interface error: unable to run macro - 0x80040552 (error when placing Structural steel truss)• Cannot run VBA module• No apparent VBA error for Mechanical tools, but there's not the usual display of mechanical content in dynamics on the cursorTo verify the issue is the result of the Microsoft Security Updates for April , please recall the file properties for MSCOMCTL.OCX (c:\windows\System32 – 32-bit OS, c:\windows\SysWow64- 64bit) and validate the File version is 6.1.98.33 and Product version is 6.01.9833.
Please note that resolving VBA problems may require the intervention of your IT support teams or services as these are primarily Windows system matters. Some level of administrative permission is needed for most of the potential solutions.
Resolution:Note: Uninstalling any of the applied Microsoft Security Updates will not correct the problem nor does Bentley recommend uninstalling any Microsoft security updates. The MSCOMCTL.OCX will need to re-registered.To re-register the MSCOMCTL.OCX on Window 7– 64bit:
1. Open the Start Menu.2. In the white line (Start Search) area, type cmd to initiate the command prompt3. Right click on cmd (at top), and click on Run as administrator.4. Click on Continue in the UAC prompt.5. Change your source directory to “c:\windows\SysWow64” by typing cd c:\windows\SysWow646. Type regsvr32 MSCOMCTL.OCXTo re-register the MSCOMCTL.OCX on Window XP/7– 32bit:1. Open the Start Menu.2. In the white line (Start Search) area, type cmd to initiate the command prompt3. Right click on cmd (at top), and click on Run as administrator.4. Click on Continue in the UAC prompt.5. Change your source directory to “c:\windows\System32” by typing cd c:\windows\System326. Type regsvr32 MSCOMCTL.OCX
Or download the attached file and rename the extension from .txt to .bat and right-click and click on Run as administrator