Share via

Incorrect/missing Registry data that is preventing VBA from running

Anonymous
2017-11-08T13:12:12+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-11-08T21:50:15+00:00

    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

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2017-11-08T14:41:13+00:00

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

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-11-08T14:01:41+00:00

    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

    1. 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

    Was this answer helpful?

    0 comments
  4. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2017-11-08T13:29:54+00:00

    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...

    Was this answer helpful?

    0 comments