Is there a way I can delete all .tmp files from my "S:\" directory?

[tonywatsonhelp]

Hi Everyone,

I'm being invaded by excel tmp files, I have the IT network guy looking into it but I'm hoping someone can help me with a quick work around why he is taking his time fixing the problem

What I would like is a macro that when I run it deletes all .tmp files from my "S:" including subfolders and folder in folders?

how can I do this?

PS. I don't need advice as to why this shouldn't happen or anything, as I say we are getting it fixed, but in the mean time just need a simple macro to this this for me.

Thanks

Tony

 

[RoryA]

You should really only need one line:

shell "cmd /k ""del S:\*.tmp /s"""

 

[tonywatsonhelp]

Worked great thanks rory