/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 vote201 views1 answer
Vba sheet visible
VBA
0 vote225 views1 answer
Get month number from month name vbnet
VBA
0 vote198 views1 answer
Do while not vb.net
VBA
2 votes149 views2 answers
Vba exit loop
VBA
3 votes234 views1 answer
Extract word in a text in excel
VBA
0 vote196 views1 answer
Afficher un message d'erreur vba
VBA
0 vote222 views1 answer
Vba code to select image in sheet
VBA
0 vote238 views1 answer
Set datetimepicker value to null vb
VBA
1 vote198 views1 answer
Excel vba get column name from number
VBA
0 vote215 views1 answer
Vbnet chart make 0 gridline line different color
VBA

Share