4 Replies Latest reply on Oct 23, 2018 3:46 AM by Jerome De San Nicolás

    References in vba for all version ?

    Jerome De San Nicolás

      Hello,

       

      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" ?

       

      Thanks