| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ftp to Unix | Excel Discussion (Misc queries) | |||
| Connect PC to UNIX via TCP/IP | Links and Linking in Excel | |||
| Unix to Excel question | Excel Discussion (Misc queries) | |||
| Unix Time Function | Excel Worksheet Functions | |||
| Unix Time in Excel | Excel Worksheet Functions | |||
Linear Mode
