Make standalone or better add-in
Jerome De San Nicolás wrote:
But what is the good practice to make a macro "update-proof" ?
Technically you cannot.
VBA macro need to reference libraries that are installed on the computer. Unless you make a installation package including all the libraries you need. In your case, you need to make sure all computer have same version of Excel installed. I don't know if the macro will run without Excel.
You could try reference the oldest version you can find. Since newer versions are supposed to be backward compatible.
Thanks for your answers.
For now I think I'll go with Frederick Law proposal.
The early / late binding stuff works but I can't make all the library functions to work (like dim as range for example).
At term, I really need to take a training in making add-in...