checking for a file

[q4s72534]

How do i write a script that will check to see if a file is in a certain location before I try to fetch it. thanks

 

[Bowers74]

Try this:

Sub FileExists()
dim fso
dim f as boolean
Set fso = CreateObject("Scripting.FileSystemObject")
f = fso.FileExists("C:\My Documents\File.xls")
End Sub

f will be TRUE if the file exists and FALSE if not

I hope this helps

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!