/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

3 votes392 views2 answers
Vba active workbook path
VBA
1 vote364 views1 answer
Excel format cell as kilowatts
VBA
5 votes405 views2 answers
Excel vba write to the windows registry
VBA
1 vote345 views1 answer
Vba delete array element
VBA
0 vote385 views1 answer
Excel vba urlmon
VBA
0 vote384 views1 answer
Nested if else in vb.net
VBA
0 vote336 views1 answer
Vba apostrophe chr
VBA
1 vote346 views1 answer
Excel vba first and last row and column in range
VBA
1 vote385 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote374 views1 answer
Return na vba
VBA

Share