Unix files
 

Hi All,
I have files in unix in the following path "/data/fcfiles/fgfiles" every day
files will be ftp'd, my query is I want "Yes" next to file name in excel if
files it is avilable or "No"
Example of files: -
UUD
UUI
UUL
UVK
421
425
478

TIA

Unix files
 

I think you need a simple UDF function. Call with

=IsFile("/data/fcfiles/fgfiles/"&A1) where A1 is the filename.

Function IsFile(FName)
if Dir(FName) = "" then
IsFile = "No"
else
IsFile = "Yes"
end Function

"kiran" wrote:

Hi All,
I have files in unix in the following path "/data/fcfiles/fgfiles" every day
files will be ftp'd, my query is I want "Yes" next to file name in excel if
files it is avilable or "No"
Example of files: -
UUD
UUI
UUL
UVK
421
425
478

TIA