Excel VB File Search File System Object Behavior.

[Max_Taylor]

I found a great piece of code that searches for a file across a folder and all subfolders and it works very well, generally.

However, when I search for files in "C:\Program Files (x86)" (to which I do NOT have write rights) or even across a shared network drive to which I DO have write rights, I get empty results. The code seems to be searching but it returns "0" files found, even though I am positive the path and file name are correct. As stated, it works fine on folders that are not admin-only.

Does the filesystemobject not work on folders that the user doesn't have write rights?

Thanks.

[Jack7774]

I am new here but I have ran into this before and I believe you are correct. If you do not have rights to the folder then you will not be able to gain access to see or open anything in the folder by simply using the search function either.