Hi Gary,

I don't need the code for delete files in use now.
Could you teach me how can I change the code to delete files when I
need to run this marco on my teammate's (users) computer, not on my
computer, so I cannot search all of drives / folders.

On Error Resume Next
Kill "C:\Users\*test*.xl*"
On Error GoTo 0

Thanks