Combine recursive listing with excluded code

[Paul_Hossler]

1. For now, remove the UCase( ) around p.path and see if the error goes away


2. Try this also

https://newtonexcelbach.com/2014/03/...-lcase-in-vba/

So mosey on over to Tools > References, and look for any library prefixed with “MISSING”.

That’s the real culprit.


If this doesn’t fix the problem, then close Excel, clean out the temp directory, clean out %appdata%\Roaming\Microsoft\Forms, then restart Excel. If that doesn’t help you probably need to repair/reinstall Office.