File Exists Formula
One note, the pathname should be in quotes unless it will be referenced by a
cell reference or variable.
HTH,
Paul
"PCLIVE" wrote in message
...
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 .....
|