Check if a list of Files exists Macro

Hi all,

I have a list of file paths in excel and want to use a macro to check if that actual files exists. I have it working where i can manually check the selected cell. However, i want to know if its possible to check the whole list in the one go - and for it to write the result in column A - either YES or NO.

I have attached what i've got so far - any help would be greatly appreciated.

Thanks,
C

Hi,

One way:

Please Login or Register  to view this content.

Hi
Paste the following codes in the macro window ( Alt f11 insert > module)

Please Login or Register  to view this content.

run the macro. it will list all files in the said folder and compares with your list and fills col E with yes or no
Ravi

That's amazin, thanks a lot!

Don't know exactly what it does but works great!

Not sure where i'd be without this forum sometimes - thanks again!