/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 vote147 views1 answer
Vba clear collection
VBA
5 votes154 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote149 views1 answer
Vbnet click on dgv cells
VBA
0 vote138 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote148 views1 answer
Excel vba open browser
VBA
0 vote147 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote141 views1 answer
Set font for ms chart vb.net
VBA
0 vote136 views1 answer
Excel vba protect sheet
VBA
0 vote129 views1 answer
Excel vba ternary
VBA
6 votes147 views1 answer
Excel vba check if a string only contains letters
VBA

Share