Solved

How to know if a file exists

Posted on 2002-05-10
4
157 Views
Last Modified: 2010-05-02
Has anyone got code to find out if a file exists before I use it in my app.
C
0
Comment
Question by:cuntacinte
  • 2
4 Comments
 
LVL 28

Expert Comment

by:vinnyd79
ID: 7001485
If Dir("C:\Filename.txt") <> "" Then
0
 
LVL 28

Accepted Solution

by:
vinnyd79 earned 50 total points
ID: 7001491
sorry about the above,this is what I meant

if Dir("C:\Filename.txt") <> "" Then
   MsgBox "File Exists!"
end if
0
 

Author Comment

by:cuntacinte
ID: 7001509
Thanks vinnyd79

C
0
 
LVL 4

Expert Comment

by:RichW
ID: 7001516
Function FileExist(Fname As String) As Boolean
    On Local Error Resume Next
   FileExist = (Dir(Fname) <> "")
End Function

' Use
If FileExist("C:\MyFile.txt" Then
   Debug.Print "File Found"
End If

0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vb6 connector to SQL Server 2 37
I need help using System.Web.HttpUtility.HtmlEncode in my VB.Net application 3 76
Advice in Xamarin 21 79
Sub or Function is not defined 6 28
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question