Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Check if File or Folder Exists in Excel VBA?

In this post, you’ll learn how you can check if the file or folder exists with in your hard-disk using Excel VBA.

How to Check if File Exists in Excel VBA?

To check if the file exists on your computer using Excel VBA, you can use the DIR command. Below is a code snippet demonstrating the same.

Sub IsFileExists ()

	Dim inputFileName As String
	Dim outputFileName As String

	inputFileName = "C:\DeveloperPublishFile.xlsx"
	outputFileName = Dir(inputFileName)

    If outputFileName = "" Then
        MsgBox "The file doesnot exist"
    Else
        MsgBox "The file exists"
    End If

End Sub

How to Check if Folder Exists in Excel VBA?

You can use the Dir function to check if the folder exists in Excel VBA as well. Below is a code snippet demonstrating how this is done.

Sub IsFolderExists ()

	Dim inputFileName As String
	Dim outputFolderName As String

	inputFileName = "C:\DeveloperPublishFolder"
	outputFolderName = Dir(inputFileName,vbDirectory)

    If outputFolderName = "" Then
        MsgBox "The folder doesnot exist"
    Else
        MsgBox "The folder exists"
    End If

End Sub