| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check if file exists
Is there an easy way in Excel to check if a file exists? I can concatenate
strings and build the full path and name of the file I want to check. I will have a few hundred file names in column A, and in column B I just want to have a formula that equals "Yes" if the file exists on my LAN or "No" if it doesn't. I can't seem to find a way to do it with Excel formulas. I'm sure this is trivial in VBA, but I don't know it. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if text exists within a cell range and return logical vaule - possible? | Excel Discussion (Misc queries) | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| check if the sheet/tag exists | Excel Worksheet Functions | |||
| check if worksheet exists | Excel Worksheet Functions | |||
| Check if a number exists in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
