Incorrect/missing Registry data that is preventing VBA from running

Question

Upon completing the Windows 10 upgrade to the latest build, running OffCAT results in critical error: 

VBA

HKEY_CURRENT_USER\Software\Microsoft\VBA\Trusted

VBA C2R Registration

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\832C86ABC73443044BA758069DBCC6E5

00005109F00000000000000000F01FEC    =C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA\VBE7.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\206169712E4CE28408A0FDE6265794FC

00005109F00000000000000000F01FEC    =C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1\VBEUI.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\VBA

Vbe71DllPath    =C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\5F9CFE2AA8001EC439EF3B3F2E6582EB

00005109E60091400000000000F01FEC    =C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1\1033\VBE7INTL.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\E570C73B47CA10F4593D3AC0C0CC62B6

00005109E60091400000000000F01FEC    =C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1\1033\VBEUIINTL.DLL

There is incorrect/missing registry data that is preventing VBA from running. Please click the 'Click here to see possible solutions to this issue' link for information on how to correct this issue.

'Clicking here' to run possible solutions to this issue, which basically meant re-running the set up without any GUI, has been  of NO help. The issue in question persists as it has been. VBAcheck from GMARK ltd results in "NO VBA INSTALLED" 

I am fairly farmiliar with on-demand installation options of ODT 2013 but still wonder how to re-install VBA properly. Any other suggestions other than MS Office 2013 complete re-install, anyone?

Moved from: Office / Install, upgrade and activate / Windows 10 / Office 2013

Answer 1

No, I don't.

I'm beginning to think there is something wrong with permissions for the following path:

C:\Program Files (x86)\Common Files\microsoft shared

Seems suspicious that the VBA library files  ARE NOT there when they should be according to the Registry. 

I have had Office 2013 installed on my PC ever since it was still running under Windows 8.1

Answer 2

If you have any other installation of Office, 2013, copy this folder from there.

Answer 3

Thanks for the suggestion. This however has NOT helped to resolve the issue with my installation

What it did do: 

1. It completely overwrote the contents in the following path

C:\Program Files\Microsoft Office 15

2. It changed the Registry keys so that running OffCAT now shows the following paths relating to the issue at question:

VBA C2R Registration

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\832C86ABC73443044BA758069DBCC6E5

00005109F00000000000000000F01FEC    =C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\206169712E4CE28408A0FDE6265794FC

00005109F00000000000000000F01FEC    =C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBEUI.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\VBA

Vbe71DllPath    =C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\5F9CFE2AA8001EC439EF3B3F2E6582EB

00005109E60091400000000000F01FEC    =C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\1033\VBE7INTL.DLL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\E570C73B47CA10F4593D3AC0C0CC62B6

00005109E60091400000000000F01FEC    =C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\1033\VBEUIINTL.DLL

Interestingly, the path below has NO files other than an empty VBA6 folder

C:\Program Files (x86)\Common Files\microsoft shared\VBA

Answer 4

Go to C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA and rename this something else say C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA.old

Now repair your office installation (You will have to do Online repair)

https://support.office.com/en-us/article/Repair...