Check if File Exists

M

Max

Is there a function or a way to check if an external file exists?

Need help ASAP!!!

Thanks in advance.
Max
 
R

Rick Brandt

Max said:
Is there a function or a way to check if an external file exists?

Need help ASAP!!!

Thanks in advance.
Max
Click to expand...

If Dir("Path to file\Filename") = "" Then
'File doesn't exist
Else
'File does exist
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
My Visio2019 Keep Crashed when open the program 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
How to remove external organization from Office. 0
Populate a table based on check box status 2
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top