Programmatically save excel changes
-
Hi all, Im trying to edit an existing excel file then save the changes programmatically without having the save confirmation window. im tryin this codes TargetExcel.Workbooks.Open(Dt.Rows(cnt).Item(2) & Dt.Rows(cnt).Item(1)) TargetExcel.ActiveWorkbook.Password = txt_password.Text TargetExcel.Workbooks.Close() ive even try to use TargetExcel.Application.DisplayAlerts = False it does eliminate the pop ups but will not save the changes on the file... any other codes or approach, tnx in advance.
-::maximus::-
-
Hi all, Im trying to edit an existing excel file then save the changes programmatically without having the save confirmation window. im tryin this codes TargetExcel.Workbooks.Open(Dt.Rows(cnt).Item(2) & Dt.Rows(cnt).Item(1)) TargetExcel.ActiveWorkbook.Password = txt_password.Text TargetExcel.Workbooks.Close() ive even try to use TargetExcel.Application.DisplayAlerts = False it does eliminate the pop ups but will not save the changes on the file... any other codes or approach, tnx in advance.
-::maximus::-