Broken Refrence Issue

[vds1]

I have developed a tool in MS Access which includes features like export to excel button. I have developed this tool in MS Access 2010 and I have referenced Microsoft excel Object 14.0 Library since I have excel 2010 in my machine.
</SPAN>
When the tool is used in other systems which have Access 2010 and Excel 2007, they get pop up error as broken reference. I have to manually change Reference to Microsoft excel 12.0 library.
</SPAN>
How can I handle these issues programmatically?</SPAN>

 

[vds1]

I figured out.

http://stackoverflow.com/questions/5729195/how-to-refer-to-excel-objects-in-access-vba