【VBA】Delete folder

You can delete folder!

PR

VBA Code

As an example, delete the folder.

folder
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).

PR

Result

You deleted folder!

PR

FYI

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

DeleteFolder method” of “FileSystemObject”

タイトルとURLをコピーしました