Nov 07 2023 12:03 AM
Hello
I have a macro which removes various characters and double spaces etc
when it's run, I could use them to save to the same step but with an addition in the file name - cleaned
can you finally run a command in the macro that does it
Nov 07 2023 11:41 PM
Use:
With ActiveDocument
.SaveAs2 Left(.FullName, InStrRev(.FullName, ".") - 1) & " - Cleaned"
End With
Nov 07 2023 11:48 PM
what if you want to get Date and time after Cleaned
so you can see what time it was Cleaned
Nov 07 2023 11:55 PM
Use
With ActiveDocument
.SaveAs2 Left(.FullName, InStrRev(.FullName, ".") - 1) & " - Cleaned - " & Format(Now, "yyyymmdd hh:MM")
End With
Nov 08 2023 12:16 AM