Awhile back I switch to Windows 10 and Excel 2016 from Windows 7 Office 12. No major problems until a new user is still running Win7 & Office 2007.

I've read that I should work in Excel 2016 and simply reference Office 12 Object library in the References - VBAproject dialog. So, I've found the Office 12 folder on my Windows 7 machine and put a copy into C:\Program Files (x86)\Microsoft Office on the Win 10 machine, exactly where the Office 16 folder is.

Now, here's the problem. The References - VBAproject Browse dialog is looking for a specific dll, not a folder with a bunch of them. If I know exactly which one (or ones) I needed, that would be OK. But I don't know that. My VBA probably uses a lot of them and I don't know exactly which one is causing my app to crash when run on a Win 7 Office 12 machine.

What am I missing?



Ed