/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 vote313 views1 answer
Excel vba existence of a file
VBA
0 vote351 views1 answer
Excel vba protect sheet
VBA
18 votes491 views3 answers
Excel-vba make integer
VBA
0 vote363 views1 answer
Vba extract filename from path
VBA
0 vote345 views1 answer
Vba test optional argument
VBA
0 vote331 views1 answer
Vba len variant
VBA
0 vote344 views1 answer
Excel vba protect content
VBA
0 vote364 views1 answer
Excel vba protect shapes
VBA
0 vote324 views1 answer
Excel vba center userform
VBA
0 vote325 views1 answer
Excel vba scroll to cell
VBA

Share