Скачать или смотреть How to check the file exists or not in VBA in excel

How to check the file exists or not in VBA in excel?
In this video, you will learn, how to check the file exists or not in VBA in excel?

Sub Get_File_Name()
Dim file As String
file = Dir("D:\Musical Programmings\")
If Len(file) = 0 Then
MsgBox "File is not exists on location.", vbCritical
Else
MsgBox file & " is exists on location.", vbInformation
End If
End Sub

Website name
AVIT Guru

Website URL
http://www.avitguru.com/

Registration Form
http://www.avitguru.com/avit-guru-cou...

Course URL
Advanced Excel & MIS
http://www.avitguru.com/advanced-exce...

VBA Macro Automation
http://www.avitguru.com/online-traini...

MS Access Database
http://www.avitguru.com/ms_access_dat...