VBA to search out and delete .tmp files

[tcfreer]

Hi all

I've been googling for 2 days on this and still have nothing.

I'm looking for some VBA code to seek out and remove all / any .TMP files that are created, across a whole server.

I'm looking cause we have a issue with in my business of files creating lots of .tmp files

If anyone has any different soloutions I am all ears

Its currently sapping me of about 10-12GB of storage a week currently

Cheers
TC

 

[MrKowz]

I'm not sure if Excel is the proper platform to handle this... you might want to look into a PowerShell script.

I did some quick Googling and turned up the following articles which might be of use:
Windows PowerShell Temp files Delete | $Env:temp
How Can I Use Windows PowerShell to Delete All the .TMP Files on a Drive? – Hey, Scripting Guy! Blog

 

[tcfreer]

Thanks MrKowz

I was abit hesitant about using Powershell, I'll give it a go though

Would going through a Terminal Server be of a issue do you think?

 

[MrKowz]

That shouldn't be an issue, as long as you're on a domain administrator profile, I believe. If you are a server admin, I would highly recommend learning PowerShell. I was an incident manager for an IT company for a few years, and PowerShell scripting was a godsend once we got someone who was capable of it. It allows you to not only take care of huge manual tasks such as what you're looking to accomplish.... but you can use it much like any other scripting language to develop repeatable, scalable, processes.