/VBA/Excel vba existence of a file

Excel vba existence of a file

Excel vba existence of a file

' Existence of a file 
If Dir("C:\myDirectory\myFile", vbDirectory) = vbNullString Then
    MsgBox "Doesn't exists"
Else
    MsgBox "Exists"
End If

0

Similar codes

2 votes242 views1 answer
Excel vba extract file name
VBA
0 vote238 views1 answer
Vbs expand env var
VBA
0 vote221 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote230 views1 answer
Vba refresh pivot table
VBA
0 vote175 views1 answer
How to sort datagridview in vb.net
VBA
2 votes226 views1 answer
Date format for ms chart vb.net
VBA
0 vote229 views1 answer
Vba boolean to string
VBA
1 vote267 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote257 views1 answer
Excel vba ternary
VBA
0 vote210 views1 answer
Remove frist letter from string vbnet
VBA

Share