This works fine if filename is an excel file. But what if i want to use a .CSV file. If i change the filename to filename.csv and then i use exlSheet.Cells(irow, 4), i dont get the right information.Code:Set exlApp = New Excel.Application Set exlSheet = exlApp.Workbooks.Open("filename.xls").Worksheets(1) irow = 1 While exlSheet.Cells(irow, 1) <> "" TextBox2.Text = TextBox2.Text & exlSheet.Cells(irow, 4) & vbCrLf irow = irow + 1 Wend
Thans in advanced




Reply With Quote