Another Files search Question....

[UniversalJOC]

whilst file search is performing a search in a particular folder, is there a way to omit a sub folder from that search?
Thanks

 

[dk]

I take it you're using the code I gave you earlier? If so, then you can either choose to have all subfolders searched or no subfolders searched - you can't omit some folders but include others. To omit all subfolders do something like this:-

.SearchSubfolders=False

If you want something else then please be a tad more specific i.e. which folders do you want to include/exclude?


Regards,
D

 

[UniversalJOC]

The only thing now is that the file names and locations that are the result of the search are logged in A1 downwards. Is there a way to stop this record being made and just open the appropriate files? (So that the button can be used over without having to delete the data? if this makes any sense)

 

[dk]

Just take out the line that says

Cells(lngLoop,1) blah blah

D

 

[UniversalJOC]

Ok, instead of not listing the file names found, is it possible to choose where they are displayed? and then clear them once they have been used?