pctechguide.com

  • Home
  • Guides
  • Tutorials
  • Articles
  • Reviews
  • Glossary
  • Contact

VBA Macro to Delete All TMP Files in Multiple Folders

I have done a lot of work with Photoshop, where I end up having a ton of annoying TMP files after running a large batch action. This can take up unnecessary storage space and make it harder to sort through useful files.

Finding and deleting TMP files can be a huge pain. You can go to folder and search for all files by putting .TMP in the search box. However, there are reasons this may not work:

  • You may have a very large set of files and the computer may not be able to search through all of them.
  • You may have files in numerous folders that don’t even necessarily have the same parent folder.
  • It may accidentally identify files that are not TMP files that have the letters TMP in the file name.

This means that it can be better to use a VBA macro. This macro will go through all of the folder paths shown in column A and delete every TMP file in them.

Sub DeleteTmpFiles()
Dim FolderPath As String
Dim FileName As String
Dim FileSystem As Object
Dim objFolder As Object
Dim objFile As Object
Dim LastRow As Long
Dim i As Long

' Create an instance of the FileSystemObject
Set FileSystem = CreateObject("Scripting.FileSystemObject")

' Find the last row with data in column A
LastRow = Cells(Rows.Count, 1).End(xlUp).Row

' Loop through each cell in column A
For i = 1 To LastRow
    ' Get the folder path from column A
    FolderPath = Cells(i, 1).Value

    ' Check if the folder path is valid
    If FileSystem.FolderExists(FolderPath) Then
        ' Set objFolder to the folder path
        Set objFolder = FileSystem.GetFolder(FolderPath)

        ' Loop through each file in the folder
        For Each objFile In objFolder.Files
            ' Check if the file is a TMP file
            If LCase(Right(objFile.Name, 4)) = ".tmp" Then
                ' Delete the TMP file
                objFile.Delete
            End If
        Next objFile
    Else
        ' Display a message if the folder path is invalid
        MsgBox "Folder does not exist: " & FolderPath, vbExclamation
    End If
Next i

' Clean up objects
Set FileSystem = Nothing
Set objFolder = Nothing
Set objFile = Nothing

' Display a message when the task is completed
MsgBox "TMP files deleted successfully!", vbInformation

End Sub

Temporary files can take a lot of space over time. This can cause your computer to run more slowly if you are not careful. Therefore, it is a good idea to get rid of TMP files that you don’t need any more.

This macro will get rid of them automatically for you. You probably don’t need temporary files much after you have finished a project, so this can be a great way to have more free memory.

Filed Under: Articles

Latest Articles

Safe Mode Editing

Repeat the same process as used previously to make a backup copy of the current boot.ini file. This time, however, when the file has been opened in Notepad... ... locate the [Operating Systems] section. Copy the entry beneath this that relates to your default operating system, and paste … [Read More...]

A Comparison Chart of Intel’s Chipsets from 915P to P965

The following table compares a number of major characteristics of Intel's mainstream desktop chipsets from the P965 to the 915P. Intel P965 Express Chipset Intel 955X Express Chipset Intel 945P Express Chipset Intel 915P Express Chipset Target Segment Performance … [Read More...]

Digital Camera Connectivity

Despite the trend towards removable storage, digital cameras still allow connection to a PC for the purpose of image downloading. Until the late 1990s the principal method of transfer was via a conventional RS-232 serial cable at a maximum … [Read More...]

Why Internet Bundles Are the Next Battleground for Gamers

A weak internet connection can turn seamless gaming sessions into frustrating experiences filled with lag, buffering or sudden disconnects. For … [Read More...]

Importance of Inbound Marketing in the Digital Age

A couple of months ago, Zacks reported that Hubspot was starting to make some major changes to its inbound marketing strategy. They talk a lot about … [Read More...]

Damage Control Strategies for Resolving Online PR Crises

Last July, Astrologer faced a major crisis after its CEO went viral at a ColdPlay concert when having an affair. This was just one of the many times a … [Read More...]

AI is Not Killing Computer Jobs Like Doomers Projected

There is no denying the reality that AI technology has played a massive role in disrupting our lives. A growing number of people claim that AI … [Read More...]

Everything You Need to Know About Sourcing Circuit Boards From U.S. Suppliers

In This Article This article includes: Why Source PCBs From the United States?How to Get a Quote From a U.S.-Based PCB ManufacturerThe Top U.S. … [Read More...]

Top Taplio Alternatives in 2025 : Why MagicPost Leads for LinkedIn Posting ?

LinkedIn has become a strong platform for professionals, creators, and businesses to establish authority, grow networks, and elicit engagement. Simple … [Read More...]

Guides

  • Computer Communications
  • Mobile Computing
  • PC Components
  • PC Data Storage
  • PC Input-Output
  • PC Multimedia
  • Processors (CPUs)

Recent Posts

Midi Sound Cards

The Musical Instrument Digital Interface, or MIDI, has been around since the early 1980s. It was developed to provide a … [Read More...]

Serial ATA (SATA) interface guide

In 1999 the Serial ATA (SATA) Working Group was formed, a group comprising companies as illustrious as APT Technologies, Dell, IBM, Intel, … [Read More...]

7 Fun Science Activities for Children

Getting a head start on creating the scientists of tomorrow should happen at a young age. However, even if your kid doesn't become an astrophysicist, … [Read More...]

[footer_backtotop]

Copyright © 2026 About | Privacy | Contact Information | Wrtie For Us | Disclaimer | Copyright License | Authors