using VB.NET 2005 filling in Excel workbook
Auto filling an excel spread with data from SQL. I need to be able to continue with the dataset into a new added worksheet. Right now it just goes back to the original sheet and continues with the data there overriding the old data.
excelBook.Sheets.Add() --> adds the sheet fine
excelBook.Worksheets("Sheet" & excelBook.Worksheets.Count).Range(Chr(yr) & i.ToString).value = "TEST" --> this codes me to the new sheet and even add in a value but i want to continue with the dataset