Dim instance As XlFileAccess workbook = APP.Workbooks.Open("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx") worksheet = workbook.Sheets("stats") Dim lastrow As Range = worksheet.Rows.End(XlDirection.xlUp) TextBox2.Text = worksheet.Rows(lastrow.Row.count, 2).Value workbook.Save() workbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx") APP.ActiveWorkbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx") APP.Quit() End Sub
Dim findme As Range = excel.Range("A1:A" & lastrow.row)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)