/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 vote119 views1 answer
Vba copy paste value only
VBA
0 vote116 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote120 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote118 views1 answer
Vba add month to date
VBA
0 vote115 views1 answer
Vba word pdf table to excel
VBA
0 vote131 views1 answer
VBA Loop to range
VBA
0 vote130 views1 answer
Weekday vba
VBA
0 vote132 views1 answer
Vba dictionary clear
VBA
1 vote135 views1 answer
Vba login website
VBA
0 vote123 views1 answer
Vbscript abs
VBA

Share