question

Anbuselvam avatar image
0 Votes"
Anbuselvam asked Anbuselvam edited

VBA Code for auto save excel sheet with TimeStamp

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!

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers