/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 vote232 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote212 views1 answer
Excel vba milliseconds
VBA
5 votes219 views1 answer
Excel vba high word from Long Integer
VBA
0 vote238 views1 answer
Windows Forms dark title bar
VBA
0 vote238 views1 answer
Excel vba first working day month
VBA
1 vote175 views1 answer
How to open cmd with vbd
VBA
0 vote216 views1 answer
Excel vba center userform
VBA
0 vote235 views1 answer
Excel vba open browser
VBA
0 vote208 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote232 views1 answer
Convert unix to date vba
VBA

Share