Substitute for FileSearch in Excel 2007

[dwain]

Hi, Trying to find a replacement for the filesearch function so this macro can be used in Excel 2007 and previous versions. The below works in Excel 2003, can anyone modify this Sub so it will work in 2007... Thanks Dale 'Milkybar Kid'..

Please Login or Register  to view this content.

[royUK]

There's an alternative here

http://www.excel-it.com/Excel%202007/excel_2007.htm

[Kenneth Hobson]

The DIR() method is fine for cases where you don't need subfolder files.
e.g.

Please Login or Register  to view this content.

[dwain]

Thanks Guys, As a VB novice, is there any chance someone can amend my coding so it will work as I'm having a bit of trouble with it.. Cheers again

[Kenneth Hobson]

Without testing, it might go something like:

Please Login or Register  to view this content.

[dwain]

Thanks Kenneth, works a treat, just need to output as csv file with that formatting... any ideas ?

[Kenneth Hobson]

Try recording a macro and do a File > SaveAs, and set the type as CSV. We can dress it up from there if needed.