AnsweredAssumed Answered

References in vba for all version ?

Question asked by Jerome De San Nicolás on Oct 22, 2018
Latest reply on Oct 23, 2018 by Jerome De San Nicolás



I have a question about references in vba, how can you (if you can) made a macro working on every version of a program ?


For example I have a macro with the "Microsoft Excel 16.0 Object Library" that work well. But on some computer, the macro won't run because of an older library reference "Microsoft Excel 15.0 Object Library" in my case. I guess the issue is the same for all programs.


I looked at "early and late binding", import references directly in the code, update all the computers ....


But what is the good practice to make a macro "update-proof" ?