/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

8 votes218 views1 answer
Excel vba make integer
VBA
0 vote191 views1 answer
Vba apostrophe chr
VBA
0 vote221 views1 answer
Find database connection string vb
VBA
0 vote215 views1 answer
How to format a textbox as date vb net
VBA
1 vote218 views1 answer
What does vbs stand for
VBA
4 votes206 views1 answer
Excel vba check cell not empty
VBA
0 vote212 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote219 views1 answer
Remove last 8 characters from string vb
VBA
0 vote223 views1 answer
Vba file chooser
VBA
0 vote216 views1 answer
Vbnet cycle through charaters in string
VBA

Share