VB.NET reference file (EXCEL)

Posted on 2006-06-05
Last Modified: 2010-04-17
Where is the reference file located in order to read an excel file in VB.NET?
Question by:SynapcoCanada
    LVL 65

    Expert Comment

    by:Jim Horn
    Microsoft Excel {Your Version} Object Library

    C:\Program Files\Microsoft Office\Office\EXCEL{Your Version}.olb

    Office may be Office11 or Office12, depending on your version

    9 = Excel 2000
    10 = Excel XP/2002
    11 = Excel 2003

    Hope this helps.
    LVL 44

    Accepted Solution

    Hi SynapcoCanada,

    depends on what you need

    this is ADO.NET

    this is using Interop,39026540,39285438,00.htm

    if you use COM interop as in the last sample you need to reference Excel in the COM Tab of your project references

    share what you know, learn what you don't

    Featured Post

    Course: Create Mobile App Prototypes with Adobe XD

    This is a project-based course: we go through all the steps of creating a prototype from start to finish, using all the tools and features currently available in Adobe XD. You can complete the course in less than a day, plus all project files and fonts are included.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    bigDiff challenge 17 57
    static class 3 44
    linearIn  challenge 23 54
    Changing the installation path of this MSI 5 75
    This article will show, step by step, how to integrate R code into a R Sweave document
    A short article about problems I had with the new location API and permissions in Marshmallow
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now