//Save to excel file
public void saveExcel()
{
//set current date to be written as excel file name
FileName_data fileName = new FileName_data()
{
currentDate = currentDate,
currentUser = currentUser,
excelPath = excelPath
};
WriteToExcel.saveExcelFile(fileName);
System.Threading.Thread.Sleep(10000);
}
public static void saveExcelFile(FileName_data fileName)
{
MyApp.DisplayAlerts = false;
MyBook.SaveAs(fileName.excelPath + fileName.currentUser + "-" + fileName.currentDate + ".xlsx");
}
