Unix files

  • Thread starter Thread starter kiran
  • Start date Start date
K

kiran

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
 
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
 
Back
Top