Im after some code that will check to see if a file exists in a specifi
location.

Ive been given the below two examples but i cant get them to work.


example 1

if Not Dir("C:\DATA\YOURFILE.XLS") then
'the bugger isnot there!
end if


example2

Sub DoesFileExist()
Set MyFile = CreateObject("Scripting.FileSystemObject")
MsgBox MyFile.FileExists("c:\filename.xls")
End Su

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=40039