As said: I have a working VB6 installation and also a functional MS Office 16 (2016) package on my Win10 laptop. Everything runs as it should, but: I cannot reference the EXCEL (or any other office) library in VB for a current small project I am tinkering with. It simply is not listed, "missing in action".
The VB lib menu allows to 'search' for additional libraries, but what/where to grab the missing Office 16 lib? I do recall that all worked for earlier MS Office versions just fine. A 'Repair' of MS Office 2016 did not fix the issue.