I'm trying to use VB.NET to automate some tedious manual Excel data entry we have going on. We have an Excel file where we keep track of some tests we're running. For every test, we add a new tab/worksheet to the Excel file.
Ideally, I'd like to use VB.NET to open the excel file, automatically make a copy of the "current" tab/worksheet, and replace the data with my new test results, so all the formatting and everything stays the same.
I know how to use VB.NET to edit cells in an excel worksheet, but am having trouble copying a specific sheet.
Any comments/suggestions would definitely be welcome, thanks!