/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

1 vote223 views1 answer
Vba reverse string
VBA
3 votes252 views1 answer
Excel vba make long from two shorts
VBA
0 vote220 views1 answer
Excel vba center userform
VBA
0 vote222 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote242 views1 answer
Sort dictionary by key vba
VBA
25 votes302 views3 answers
String to date vb
VBA
0 vote206 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote222 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote217 views1 answer
Vbscript Trim
VBA
0 vote205 views1 answer
Find the name of the last excel sheet vb
VBA

Share