Check Directory if FIle exist

TO Check if file exist in a Folder

VB Code:

If Converted.txt Exist in Dir Then
 
 Open App.Path & "\210\February\Converted.txt" For Input As #1
             Do Until EOF(1)
                 Input #1, a, b, C, D
                 Set itm = lv(intInd).ListItems.Add(, , a)
                     itm.SubItems(1) = b
                     itm.SubItems(2) = C
                     itm.SubItems(3) = D
                Loop
Else
 
cmdLoad.Enabled = False
chkLoad.Enabled = False
Exit Sub
End If

vbMarkO

And your question is...?

Like:

VB Code:

If Len(Dir$(App.Path & "\210\February\Converted.txt")) <> 0 Then

Edit: Or use:

VB Code:

If Dir$(App.Path & "\210\February\Converted.txt") <> "" Then

Bruce. :)

So I guess for next time, actually ask a question instead of making a phrase then hide something in your code.

Quote:

---

Originally posted by Bruce Fox
Like:

VB Code:

If Len(Dir$(App.Path & "\210\February\Converted.txt")) <> 0 Then

Edit: Or use:

VB Code:

If Dir$(App.Path & "\210\February\Converted.txt") <> "" Then

Bruce. :)

---

That worked great thank you...

As for the guys Oooops my Bad forgot to put a ?

Glad he caught it though

Ill try harder next time!!!

vbMarkO