Daniel

I have to check if a file exist, caus when it don''t excists i have to un an other file, so what will be the code to check if a file excists

RemoteHoax

check the Dir function

Daniel

I can''t install MSDN, so i have no help function, so can u please tell me how to do it

Iceplug

The Dir$ function returns the filename given in the first parameter if it exists, otherwise it returns "".

So you can check like this:

Flyguy

Why can't you install MSDN??

You also can use MSDN online on the Microsoft website.

JDT

You could also use ArnoutV's favorite way, the FileSystemObject has a FileExists method.

j/k ArnoutV

technomag

you can use the filesystem obgect:

Public Function FileFind(FileLocation As String) As Boolean
Dim fso As FileSystemObject

Set fso = New FileSystemObject
If fso.FileExists(FileLocation) Then
FileFind = True
Else
FileFind = False
End If
End Function

the FileLocation string shuld be the full path to the file like:
c:\my documents\file1.txt

OnErr0r

ick :P

Daniel

Euhmm, i can''t MSDN because when it says locate the msdn disc, i put in the msdn disc, and it says it is the wrong disc. But anyway, u guys helped me out very much, it is working now

Hasin

MSDN has a buh in it as I think - If you want to reinstall it it shows the message "Error creating collection and does not work. I see it in all of my friends. They guess it as a bug.