N/APosted on - 09/04/2011
I am Ackley Joseph, I have designed an application which writes data in an Excel File. For this purpose I used the reference of Microsoft Excel Object Library 10.0. it works fine where there is a MS Office 2003 but I open source code on computer where there is highest or Lower version installed then report an error of Missing: Microsoft Excel 10.0 object Library.
The problem is that Visual Basic itself can’t Manage it what is the solution to avoid it.
VB Reports Error When Excel Object Library is changed
As I can see in your References – Tag in Microsoft Visual Basic, it says that the Microsoft Excel 10.0 Object Library is missing. If you have created your visual basic program with installed lower Microsoft Office applications and you are modifying it under the higher version of Microsoft Office applications, locate or find the highest version of your Microsoft Excel Object Library in your reference list. Marked it check then uncheck the other one.
One more reason of this is when you uninstalled your Microsoft Office Applications. Microsoft Excel Object Library comes from your Microsoft Office Applications and not from Microsoft Visual Basic. You need to re-install your MS applications for the Library.