filedetection ==> phantomfiles

I have not seen that, but just for the heck of it, run the code the way you have it by listing all the files in column A, then drag that list into some other column. Re-run the macro but change
SearchSubFolders = True
to
SearchSubFolders = False
and see if that changes anything.


One of the most misunderstood and misrepresented facets in the world of computers is the concept of "delete". Whether you delete the contents of an Excel cell, or a Word paragraph, or a file from the hard drive, or even employ a commercially sold "wipe" program to wipe your hard drive, the information never really leaves your hard drive after it's been put on.

Computer forensics can recover data that the user thought was deleted or wiped because hard drives never actually release the data that was put on them. The most that ever happens is data is covered with encrypted code (often binary zeros and ones), but the underlying original data is still there. Products like GoBack simply fool the hard drive into thinking the date and time is earlier than it really is, and the underlying data is uncovered, hence recovered as far as the user is concerned.

This might have absolutely nothing to do with the problem you are seeing. We have to start somewhere with your question though, and maybe (as far as your computer is concerned) your code to search all subfolders includes deleted or behind-the-scenes temporary folders where a document was first downloaded.

Tom,

thanks a lot for the intresting explanations
I tryed to do what you said ...
now nothing is found anymore !
no way to display whatsoever ?
I'm sure for 1000% that the file is in a map with other files
I tried also C:\ an D:\ (my two disks) with and without subfolders
I tried with a button in a program that's used by hunderds of people. (I let them push a button with this code to help them from distance, so I'm sure the code works normally)

more phantoms ?
Erik