I have a range in an excel document which I need to extract into a listbox. I can do this through .txt file, but really would prefer to source the information from excel. How?

I am using Visual Studio 2010 and so far my code is:

```
Public class1 Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim objXLApp As Excel.Application
Dim intLoopCounter As Integer

objXLApp = New Excel.Application

With objXLApp
    .Workbooks.Open("C:\report.xls")
    .Workbooks(1).Worksheets(1).Select()

    For intLoopCounter = 1 To CInt(.ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row)
        List1.AddItem.Range("A" & intLoopCounter)
    Next intLoopCounter

    .Workbooks(1).Close(False)
    .Quit()
End With

objXLApp = Nothing
End Sub 

```

When I build this program I get two errors;

1. statement is not valid in namespace
2. end of statement expected (I did put end class but it adds more couple of errors")