Open your Windows file explorer and navigate to C:\PPInstallFiles\Standard\ISSetupPrerequisites (or C:\APPInstallFiles\Standard\ISSetupPrerequisites for version 14 or older)
The folder names in this location are random strings. You need to go into each folder manually to locate the two VBA files:
- Vba71.msi
- Vba71_1033.msi
- Double-click each of the VBA files to install them. Each one only takes a moment to install and should not require any additional input.
We have recieved reports of this error returning in rare cases and the cause appears (though not yet proven) to be Windows update. The redistributable files above as produced by Microsoft and the licence agreement does not allow for these to be altered or integrated into Elecosoft's installer so if Windows update (or another application) is affecting VBA there is unfortunately very little Elecosoft can do to resolve the issue other than advising the redistributables are reinstalled.
The 2 files which could be impacted by this issue are vbe7.dll and apc71.dll.
Vbe7.dll is the main component for VBA and if that is affected the VBA back-end wouldn’t work in Office applications.
The apc71.dll is what Elecosoft have to use as a non-Microsoft company to access VBA. On affected systems either this dll is being deleted or its registry settings are being altered/deleted.The following registry entries are what the dll needs in the registry, so either these need to be locked down so they cannot be broken or they need to be monitored to see what other application is impacting them.
[HKEY_CLASSES_ROOT]
[HKEY_CLASSES_ROOT\CLSID]
[HKEY_CLASSES_ROOT\CLSID\{2F967C44-B1F0-485E-957C-97538BCAD2DE}]
[HKEY_CLASSES_ROOT\CLSID\{2F967C44-B1F0-485E-957C-97538BCAD2DE}\Programmable]
[HKEY_CLASSES_ROOT\CLSID\{2F967C44-B1F0-485E-957C-97538BCAD2DE}\VersionIndependantProgID]
@="MSAPC.ApcGlobal"
[HKEY_CLASSES_ROOT\CLSID\{2F967C44-B1F0-485E-957C-97538BCAD2DE}\Implemented Categories]
[HKEY_CLASSES_ROOT\CLSID\{2F967C44-B1F0-485E-957C-97538BCAD2DE}\Implemented Categories\{40FC6ED5-2438-11CF-A3DB-080036F12502}]
[HKEY_CLASSES_ROOT\CLSID\{943FA227-E90C-47DA-987B-C4DD13E48CB4}]
[HKEY_CLASSES_ROOT\CLSID\{943FA227-E90C-47DA-987B-C4DD13E48CB4}\Programmable]
[HKEY_CLASSES_ROOT\CLSID\{943FA227-E90C-47DA-987B-C4DD13E48CB4}\VersionIndependantProgID]
@="MSAPC.ApcHostAddIns"
[HKEY_CLASSES_ROOT\CLSID\{943FA227-E90C-47DA-987B-C4DD13E48CB4}\Implemented Categories]
[HKEY_CLASSES_ROOT\CLSID\{943FA227-E90C-47DA-987B-C4DD13E48CB4}\Implemented Categories\{40FC6ED5-2438-11CF-A3DB-080036F12502}]
[HKEY_CLASSES_ROOT\CLSID\{95C9DCCD-A44A-4034-84BB-D7912DF5711F}]
[HKEY_CLASSES_ROOT\CLSID\{95C9DCCD-A44A-4034-84BB-D7912DF5711F}\Programmable]
[HKEY_CLASSES_ROOT\CLSID\{95C9DCCD-A44A-4034-84BB-D7912DF5711F}\VersionIndependantProgID]
@="MSAPC.ApcCollection"
[HKEY_CLASSES_ROOT\CLSID\{95C9DCCD-A44A-4034-84BB-D7912DF5711F}\Implemented Categories]
[HKEY_CLASSES_ROOT\CLSID\{95C9DCCD-A44A-4034-84BB-D7912DF5711F}\Implemented Categories\{40FC6ED5-2438-11CF-A3DB-080036F12502}]
[HKEY_CLASSES_ROOT\CLSID\{CFE9F29B-E1B6-4240-AED7-360846769314}]
[HKEY_CLASSES_ROOT\CLSID\{CFE9F29B-E1B6-4240-AED7-360846769314}\Programmable]
[HKEY_CLASSES_ROOT\CLSID\{CFE9F29B-E1B6-4240-AED7-360846769314}\VersionIndependantProgID]
@="MSAPC.Apc"
[HKEY_CLASSES_ROOT\CLSID\{CFE9F29B-E1B6-4240-AED7-360846769314}\Implemented Categories]
[HKEY_CLASSES_ROOT\CLSID\{CFE9F29B-E1B6-4240-AED7-360846769314}\Implemented Categories\{40FC6ED5-2438-11CF-A3DB-080036F12502}]
[HKEY_CLASSES_ROOT\TypeLib]
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}]
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1]
@="Microsoft APC 7.1 Object Library"
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\FLAGS]
@="0"
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\HELPDIR]
@="C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1"
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\409]
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\409\win32]
@="C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\apc71.dll"
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\0]
[HKEY_CLASSES_ROOT\TypeLib\{A6128B1F-4A3A-40B6-B5CE-5FE8DE3D88E9}\7.1\0\win32]
@="C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\apc71.dll"