View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default File Exists Formula

I think I've used something like this before.


If Len(Dir([path and Filename])) _
Then
msgbox ("File already exists!")
end
Else:
<Your code
end if


HTH,
Paul


"El Bee" wrote in message
...
Is there a formula that can ba used in a cell to check if a file exists;
if
the file does exists then do .......

In other languages I've used : If fexists(filename) then .....