VBA Code for auto save excel sheet with TimeStamp
Anbuselvam Kovilmani
41
Reputation points
Dear Excel Genius
I need a VBA code to AutoSave excel sheet with time stamp DD:MMM:YYYY_HH:MM:SS_FileName.
Whenever I opened the file it has to save on OpenBackup Folder which is located in the same file path
Whenever I Close the file (Save or Don't Save) it has to save on ClosingBackup Folder which is located in the same file path
Both open and closing files have to TimeStamp and the Password of "Password"
But the original file needs to save in its original location as per my Save or Don'tSave option selection with its original name.
Thanks in Advance!
Sign in to answer