//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"); }