Tech Off Post

Single Post Permalink

View Thread: Value of Excel cell into VB label
  • User profile image


    I am trying to get data FROM an Excel solution INTO Visual Basic 2005.

    I have already added a reference to the Microsoft Excel 9.0 Object Library in Solution Explorer.

    There is a file c:\theproject\theproject1.xls


    1. How do I get Visual Basic 2005 to connect to theproject1.xls?

    2. How do I get the value of the Excel solution cell B12 INTO A LABEL (named thelabelB12) in the Visual Basic 2005?

    Thank you.