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
|