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 Oct 22, 2018 8:40 AM

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

Re: References in vba for all version ?

Deepak Gupta Oct 22, 2018 11:23 AM (in response to Jerome De San Nicolás)

Make standalone or better add-in
Like Show 2 Likes(2)

Actions
Re: References in vba for all version ?

Frederick Law Oct 22, 2018 11:36 AM (in response to Jerome De San Nicolás)

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.
Like Show 5 Likes(5)

Actions
Re: References in vba for all version ?

Fifi Riri Oct 22, 2018 1:38 PM (in response to Jerome De San Nicolás)

Hello, Take a look at :
Office VBA: Reference downgrade problem – Visual Studio Office Development (VSOD) Support Team
Like Show 2 Likes(2)

Actions
Re: References in vba for all version ?

Jerome De San Nicolás Oct 23, 2018 3:46 AM (in response to Jerome De San Nicolás)

Hi,
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...
Like Show 0 Likes(0)

Actions

Go to original post