Application.FileSearch not working in 2007

clut

Sorry your out of luck if you must use Application.FileSearch, it's just not supported in Excel 2007.

You should try another method of searching for files, perhaps the File System Object.

Ok, I've had a look through the link you sent me, and I now have Excel outputting a list of all folders within a certain directory. I have tried to modify this code to output all files in all folders but it doesn't work.

The example looped through each folder in an fso.getfilefolder, and I tried to loop through each file within each folder. I would normally sit down and work this out myself, but the help system isn't, and I can't really spend all day tucked away in here coding when I should be spending time with the family.

Many thanks

I suggest you look at the 2nd page of the link - Using The FileSystemObject With VB and VBA - Part 2.

And I agree with you about the family thing - I'm just about to head off to mine.