Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Wednesday, October 10, 2018 7:26 AM
need a help.
I want to download the the microsoft excel 16.0 object library.
Because I want read Excel data to use VB on VS2012 , so I want to that.
I did search "Reference Manager" -> "COM" -> not found "Microsoft Excel 16.0 Object Library".
How to download the microsoft excel 16.0 object library??
thank you.
All replies (4)
Wednesday, October 10, 2018 12:50 PM âś…Answered | 1 vote
The type library for any Office application (including excel) is installed as a part of the Office installation. And the type libraries are version specific (i.e., which version of Office is installed).
For example, Office 2007 was version 12.0, Office 2010 was version 14.0, Office 2013 was version 15.0 and Office 2016 is version 16.0
Generally speaking, if Office is not installed on your development system, the related type libraries will not be available. And if I remember correctly, the type library for Excel is not contained in a separate .tlb or .olb file but is embedded as a resource in Excel.exe.
I am not aware of any separate download offered by Microsoft for Office application type libraries.
Wednesday, October 10, 2018 11:39 AM
You can reference to Microsoft.Office.Interop.Excel Dll which will also help manipulate excel data.
Refering to your question - Microsoft Excel 16.0 Object Library will not be available for VS 2012 - probabaly look for Microsoft Excel 12.0 Object Library.
Add Reference -> COM -> Microsoft Excel 12.0 Object Library
Thanks,
Vivek Bansod
Blog | MSDN | LinkedIn
Thursday, October 11, 2018 2:58 AM
Hi Tanko55,
Welcome to the MSDN forum.
Like RLWA32 said, please try to download the Office 2016 from https://products.office.com/en-sg/get-office-oem-download-page and install it, then you can use the Microsoft Excel 16.0 Object Library.
For more development issues about the Office and Excel, please redirect to this appropriate forum for a better support, since our forum is to discuss the VS IDE, thank you for your understanding.
BTW, if you think RLWA32's reply is helpful for your issue, please mark it as answer and that will help others to easier search this useful information, we can also close this thread for you :)
If you have any other IDE issues later, please feel free to let us know.
Best regards,
Sara
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
Friday, October 12, 2018 7:53 AM
thx RLWA32.
You were ans to help me. :)