Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make excel check external file paths
I have a spreadsheet which contains thousands of file paths going doing
column A. I wanted excel to be able to look at cell A1, A2 and so on and check if the file does exist on the harddrive and then return in cell B1 return Yes or No. I wanted this to loop until it reaches the end of the file paths and has returned yes or no for all of them. Thanks in advance. Stuart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel file paths | Excel Discussion (Misc queries) | |||
How to check if external .txt file has text in it... | Excel Programming | |||
file paths | Excel Discussion (Misc queries) | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Relative paths to external data? | Excel Discussion (Misc queries) |