/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

1 vote158 views1 answer
Excel date to unix timestamp
VBA
0 vote145 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote151 views1 answer
Vba find last column in a row with data
VBA
2 votes102 views1 answer
Excel vba pause
VBA
0 vote158 views1 answer
Date as number vb
VBA
0 vote150 views1 answer
Vbnet line chart showing extra space
VBA
8 votes170 views1 answer
Run command pormpt in background windows
VBA
0 vote147 views1 answer
Limit combobox to list vba
VBA
0 vote150 views1 answer
Excel vba range contains
VBA
0 vote161 views1 answer
Vba min
VBA

Share