Late-binding and Adding references

[simurq]

I have two questions which really bother me and I'd like to solve them before going further coding...

# For the sake of compatibility with previous versions of Excel, I think of using late-binding but if the referenced library:

i) is not available on user's system, I have to notify him about the missing library.
ii) is not referenced, I have to add the reference programatically.

True / False?​

# How can I know the numbers of errors likely to occur when adding the references to ensure proper error-handling?

Thanks!

 

[Kenneth Hobson]

To be safe, delete the special references before using in production. Many will code in both and then remove the early binding references in the production version.

If you must use early binding and want to handle an errors, you will have a lot to consider. Solutions depend on the GUID. Here is one example for one library object. https://www.mrexcel.com/forum/excel...s-microsoft-activex-data-objects-library.html

 

[simurq]

Thank you, Kenneth!

Yes, that's the plan indeed. I will delete the references and use late-binding when my app is released. But AFAIU the whole point of late-binding is if used properly, there is no need to add references programmatically. Is that correct?

 

[Kenneth Hobson]

Right. There are pros and cons to both approaches.