/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 vote258 views1 answer
Vbscript Trim
VBA
1 vote228 views1 answer
Excel vba unload userform
VBA
7 votes227 views1 answer
Vba array declaration
VBA
1 vote227 views1 answer
Random number generator vb.net
VBA
0 vote233 views1 answer
Vba min
VBA
0 vote279 views1 answer
How to call gcd in vba
VBA
1 vote238 views1 answer
If inputbox cancel vba
VBA
0 vote230 views1 answer
Vba file chooser
VBA
0 vote233 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote227 views1 answer
Vbs send keys
VBA

Share