Dear Excel Guru’s,

I need help to create a VBA code to save an Excel file without prompt upon exit and create another file as backup (Save As) with filename plus the current date.

The file is save at G:\Data\Trans_Data.xlsb and the Save As file is to be save at Z:\Backup\Trans_Data MM-DD-YY.xlsb. If the file is Save at same date, overwrite the file without any prompt.

Thank you in advance.