I build Excel apps that I distribute across a very large company.
Becuase I can't be sure of the end-user's OS or version of Office, I almost always use Late Binding, so that I don't have to set a reference in the project for a specific version of a library.
This means that I've gotten very good at Late Binding, but I have little experience with Early Binding.
My latest code uses ADODB to query an Access DB. ADODB Late Binds quite nicely, but when I remove the reference, I lose the constants, such as adOpenStatic. I see that I have two options: switch to Early Binding and add a reference to the project, or keep Late Binding, and use literal integers instead of constants.
What happens if a project contains a reference to a NEWER version of ADODB? Does it run the older version or just error out?
This might be a silly question, but for obvious reasons I am unable to test this on my own machine.
Advice please.