Using Late Binding in creating custom ribbons

[Demerit]

Hi to all!



I am using Office 2010 in a windows 8.1 machine. Recently i created an access application with custom ribbons. In my machine, I make reference to the Microsoft 15.0 Object Library (Thats what is available on my PC), but in other clients machines (running windows 7 and office 2010) that i have had to install, I get the reference error message. They instead have Microsoft 14.0 object library.

My worry is about the referencing stuff. Is there a VBA code (Late Binding) containing the object that are needed to create a custom ribbon so i dont have to worry or know the version of office a client is using.

I have compiled my access application to executable (accde) and I have created a setup for it as well. One of the difficulties is that i cannot get to the code any more when the access application is already compiled to "accde" (which i dont want to do it any ways, not infront of my client).

Please I will need your assistance getting me a late binding vba code that defines objects needed to creating a custom ribbon.

Thanks in advance.

[JamesDeckert]

are you using XML or VBA to build your custom ribbon?
Is installing on the clients computer Access 2013 runtime an option? That might fix the problem.
Maybe you could provide a snippet of your code to look at.

[June7]

This article describes setting a library reference with VBA https://msdn.microsoft.com/en-us/lib...or=-2147217396

I've never tried so don't know if it really works.