【VBA】Delete folder

You can delete folder！

Contents

VBA Code
Result
FYI

VBA Code

As an example, delete the folder.

Option Explicit

Sub sampleProc()
    
    Dim fso As Object
    Dim folderFullPath As String
    
    'Set "Folder path you want to delete"
    folderFullPath = "C:\Users\user\Desktop\hogehoge"
    
    Set fso = CreateObject("Scripting.FileSystemObject")
    
    'Delete Folder
    fso.DeleteFolder (folderFullPath)
    
    Set fso = Nothing
    
End Sub

Set “Folder path you want to delete”(Line 9).

Delete Folder(Line 14).

Result

You deleted folder！

FYI

For more information about following, see the following official online manual:

●“DeleteFolder method” of “FileSystemObject”

DeleteFolder method (Visual Basic for Applications)

Office VBA reference topic