/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

0 vote189 views1 answer
Excel delete ever other vba
VBA
0 vote186 views1 answer
Excel run macro every 5 minutes
VBA
0 vote191 views2 answers
Excel vba protect cells with formula
VBA
0 vote191 views2 answers
Excel vba number format file size
VBA
0 vote183 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote213 views1 answer
Create new worksheet excel visual basic
VBA
-1 vote193 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote184 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote184 views1 answer
Rotate image by any angle vb.net
VBA
1 vote206 views1 answer
Excel vba first row in range
VBA

Share