I found the solution posted on the Solidworks forum after some Google digging:
Make sure the following items exist in your registry:
[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}] [HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3] "PrimaryInteropAssemblyName"="Microsoft.Vbe.Interop, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" @="Microsoft Visual Basic for Applications Extensibility 5.3" [HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\0] [HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\0\win32] @="C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB" [HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\FLAGS] @="0" [HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\HELPDIR] @="[{0002E157-0000-0000-C000-000000000046}]"
Note: You could download & import the above registry keys into your registry as a .reg file from the original post below.
Source: https://forum.solidworks.com/thread/40593