/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 vote181 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote165 views2 answers
How to concatenate more than 40 lines in vba
VBA
4 votes117 views2 answers
Vba last row
VBA
0 vote178 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote176 views1 answer
Vbnet line chart showing extra space
VBA
0 vote161 views1 answer
Vba change named range address
VBA
1 vote173 views1 answer
Excel vba get column number from column name
VBA
0 vote170 views1 answer
Excel vba range contains
VBA
1 vote160 views1 answer
Vba delete array element
VBA
0 vote178 views1 answer
VBA is form loaded
VBA

Share