Excel Information

[lothos12345]

I am trying to move information from an Excel Spreadsheet into a listbox using VB.NET. Being relatively new to VB.NET I am not sure exactly how to accomplish. I read about how to Create an Excel object to move information from the program into Excel but I need to understand how to open an Excel File and move the all the information from the Spread into Listbox in the program. Any help with this would be greatly appreciated.

[hog]

You need to add a COM reference to Microsoft Excel 10.0 Object Library then all the methods and properties will become visible to you:

 

DIM objExcel as New Excel.Application