vds1
Well-known Member
- Joined
- Oct 5, 2011
- Messages
- 1,200
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>
</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>