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
|