Forum Discussion
add to the file name and save it again with macro
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
4 Replies
Use:
With ActiveDocument .SaveAs2 Left(.FullName, InStrRev(.FullName, ".") - 1) & " - Cleaned" End Withwhat if you want to get Date and time after Cleaned
so you can see what time it was CleanedUse
With ActiveDocument .SaveAs2 Left(.FullName, InStrRev(.FullName, ".") - 1) & " - Cleaned - " & Format(Now, "yyyymmdd hh:MM") End With
