/VBA/Excel vba folder exist

Excel vba folder exist

Excel vba check if directory exists

Public Function IsDir(s)
    IsDir = CreateObject("Scripting.FileSystemObject").FolderExists(s)
End Function

22

Source: academy.excelhero.com

Excel vba folder exist

If Dir("C:\Temp\xxx", vbDirectory) = "" Then
    MsgBox "Doesn't exists"
End If

3

Similar codes

0 vote180 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote189 views1 answer
Reference to a non-shared member requires an object reference
VBA
1 vote195 views1 answer
How to remove zeros in excel
VBA
1 vote205 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote191 views1 answer
Not allow form to be resized
VBA
0 vote185 views1 answer
Vbnet click on dgv cells
VBA
1 vote169 views2 answers
Excel vba password protect
VBA
0 vote138 views1 answer
How to self delete a vbscript file
VBA
0 vote198 views1 answer
Vba foreach 2d array
VBA
0 vote186 views1 answer
Vbscript abs
VBA

Share