/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 vote245 views1 answer
Set font for ms chart vb.net
VBA
0 vote242 views1 answer
Vba get relative cell address
VBA
0 vote246 views1 answer
Excel vba clear filter
VBA
0 vote245 views1 answer
Vba find last column in a row with data
VBA
0 vote234 views1 answer
Make all controls in an area not visable vb
VBA
22 votes309 views1 answer
Xlvba check for folder
VBA
0 vote227 views1 answer
Vba paste values
VBA
0 vote236 views1 answer
Vbnet chart make 0 gridline line different color
VBA
3 votes242 views1 answer
Vba double quote
VBA
2 votes225 views1 answer
Excel vba check if key is in collection
VBA

Share