How can I read from an MS Excel file using VB?

[mn20]

i have a list of names in an Excel file and i want it to be read by my VB application. What components/references do i need to use and what are the syntax for openning and reading that Excel file. thanks a lot!

 

[JohnYingling]

Here is how I would start.
Start up Excel. Start recording a macro(tools / macro).
Open the document worksheet you want to read. Save it as a Tab-delimited text file. Close the file. Stop recording the macro. Look at the macro to see all the code needed. There are a number of articles in MSDN about using OLE Automation

http://msdn.microsoft.com/library/d...tegratingapplicationsbyusingautomationole.htm

Use LATE-BINDING for production.

#If blnDebug then
    Dim objAPPl as Excel.Application ' Allows Intellisense
    Dim objWrkS as EXCEL.WorkSheet
#else
    Dim objAPPl as object ' Back level Excel will still work
    Dim objWrkS as object
#End if

http://WWW.VBCompare.Com