Forum Discussion
Create VBA projects that are compatible with multiple computers.
I have a small project written in VBA and has a reference to the Microsoft Office16.0 Object Library. It works on my computer (Installed Office 365) but when deploying to another computer with Office...
Although it's possible to set a reference programmatically, it is very tricky - I wouldn't recommend it.
It would be easier to use late binding: remove the reference to the Microsoft Office16.0 Object Library, and replace constants from that library with their values.
After you remove the reference, select Debug > Compile <projectname>.
See which errors you get and fix them one by one.