View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Check if a File Exists


Function IsItThere()
Dim blnFile As Boolean
Dim strPath As String

strPath = "C:\Program Files\ahead\Nero\Boo.wav"
blnFile = Len(Dir(strPath))
MsgBox blnFile
End Function
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Ray Clark"
wrote in message
I need to check if a file exists before creating a new file.