/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 vote215 views1 answer
Vba copy paste value only
VBA
0 vote230 views1 answer
Excel vba cell on change
VBA
0 vote230 views1 answer
Vba collection key list
VBA
0 vote242 views1 answer
Prive sub enter clicked vb
VBA
0 vote227 views1 answer
Excel vba StartUpPosition
VBA
0 vote257 views1 answer
How to add line graph vb net
VBA
0 vote246 views1 answer
Delete all controls in an area vb
VBA
0 vote232 views1 answer
String contins in vba
VBA
0 vote233 views1 answer
Remove series name from legendvbnet
VBA
0 vote263 views1 answer
.net crash app
VBA

Share