VBA Code for auto save excel sheet with TimeStamp

Anbuselvam Kovilmani 41 Reputation points
2021-06-29T09:14:49.433+00:00

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!

0 comments No comments
{count} votes