Dear Alan,

Thanks for your reply and also sharing your experience of similar problem.
I am aware of the docx and docm files and their respective properties.

My question is, why did it happened after running the macro in the Normal Template. My knowledge of VBA is very minimal so I could not what happened after running the code.

In case the files have been moved then it should be found on the system (somewhere). I checked the path you suggested. I tried various utilities to check whether it is moved or deleted but to no success.

It is just not there any where on the system.
Is the code renaming the files and moving or deleting them?

Hope you understand my point now.