Thread: [Solved] Adding reference to Office 12 Object Library to
View Single Post
 
Old 01-24-2018, 04:51 PM
jag_man653 jag_man653 is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Mar 2013
Posts: 10
jag_man653 is on a distinguished road
Default Adding reference to Office 12 Object Library to
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
Reply With Quote