I was cleaning up WindowsApps and VBA would not run if I deleted:
Microsoft.Office.Desktop_16051.11126.20266.0_neutral_~_8wekyb3d8bbwe
Microsoft.Office.Desktop_16051.11126.20266.0_x86__8wekyb3d8bbwe

I removed the apps and uninstalled Office and reinstalled it and it still failed saying that VBE6EXT.OLB is missing even though it was present in C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\. After restoring the apps and not doing anything else, VBA ran.

It is my understanding that these apps were connected to Office16, how is it messing up Office10?