I'd like to auto-save a looping Macro at end of each loop I run each day. I only need the latest "save", so I want it to save over the previous saves for that day. I found the simple code method below that looks like it will work, but I need help tweeking it some....
I need it to allow it to save over the previous save without the pop-up asking for permission to copy over existing file.
I need it to save as "Auto Save" & Today's date.... Such as, "Auto Save 10-18-22"
I would like to designate the name of the folder it saves to (inside the Macro only).... Currently, it saves to my general Documents folder
Here is the code I found...
I need it to allow it to save over the previous save without the pop-up asking for permission to copy over existing file.
I need it to save as "Auto Save" & Today's date.... Such as, "Auto Save 10-18-22"
I would like to designate the name of the folder it saves to (inside the Macro only).... Currently, it saves to my general Documents folder
Here is the code I found...
Code:
Dim newName As String
newName = "Auto Save"
ActiveWorkbook.SaveAs Filename:=newName