File Lister

[lhtqasonline]

Hi I'm using the vba code as posted for Directory and File-Lister My problem is i get debug error With Application.FileSearch under Sub listfilesinfoldersandsub() I guess it's Office 2007 causing it not to work Can anyone help?

[macropod]

Hi lhtqasonline,

Application.FileSearch is not supported by Office 2007. For some workarounds, see: http://www.mrexcel.com/forum/showthread.php?t=268046

[Kenneth Hobs]

I made an example using a class similar to FileSearch. http://www.4shared.com/get/87591234/8d1d705d/1839452_classFileSearch_and_Excel4.html

The classes were designed by ginismo: http://www.mrexcel.com/forum/showthread.php?t=369982

Some other methods are listed in the 2nd link as well.