/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 vote149 views1 answer
Vb check if row has column
VBA
0 vote202 views1 answer
Find control with name vb
VBA
0 vote199 views1 answer
Excel vba protect content
VBA
18 votes322 views2 answers
Vba make word from bytes
VBA
0 vote163 views1 answer
VBA Sort RossetaCode
VBA
3 votes162 views1 answer
Vba post request json
VBA
2 votes156 views1 answer
Vba round number
VBA
0 vote155 views1 answer
Excel vba calculate
VBA
0 vote145 views1 answer
Change "location" of binding navigator vb
VBA
0 vote154 views1 answer
Excel vba range contains
VBA

Share