public void moveSheetToEnd(Excel.Worksheet sheet, Excel.Workbook target)
{
// moves the sheet to the end of the workbook
int sheetCount = target.Sheets.Count;
try
{
sheet.Move(Type.Missing, target.Sheets[sheetCount]);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message, "Worksheet Move Failed", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
}