VBS for backup while saving word file

[shaft_29]

I have an excel that each time I save one more file is saved separately with the name of the respective file, to which is added the date and time of the save in the file name.
I use the macro below for this.
The same thing I would like to do for a word file, but I can't.
Please help.
Thanks.

Please Login or Register  to view this content.

[6StringJazzer]

It's not clear from your question but I am going to assume you want to do this for a Word file as a Word macro, not an Excel macro.

One issue is that Excel has a SaveCopy method but Word does not. I have solved this problem in the past by saving the document, saving it with the new name, then re-opening the original. Also, the model in Word for handling a Save event is more complex than how it works in Excel. You can read that Microsoft page for details on capturing the event, then you can call the Sub below from it.

A simpler option might be to use the Windows file system to make the copy, rather than saving as a copy. I have not tested this but it illustrates the approach.

Please Login or Register  to view this content.

[shaft_29]

Not working

[6StringJazzer]

I did test this and it turns out FileCopy will fail if the source file is open. I was able to get this to work. You will need to research how to capture the Save event in the link I provided above.

Please Login or Register  to view this content.