/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 vote360 views1 answer
Vba parameter adodb null value
VBA
0 vote371 views1 answer
Vba remove the first character of string
VBA
1 vote321 views1 answer
Excel vba get column name from number
VBA
0 vote335 views1 answer
Type excel.application is not defined vb
VBA
0 vote326 views1 answer
Excel vba extract year
VBA
0 vote390 views1 answer
Vba userform textbox wrap text
VBA
0 vote352 views1 answer
Excel vba ternary
VBA
0 vote346 views1 answer
WGET FTP
VBA
1 vote319 views1 answer
Textbox find and replace vb
VBA
0 vote353 views1 answer
VBA is form loaded
VBA

Share