Actually Filesearch did not work all that well. It was removed from XL 2007.
You can use the "Dir" function or the ScriptingRuntime "FileSystemObject".
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Libby"
wrote in message
Hi all,
I have a list box that is populated by code to show the contents of a folder.
I use the Application.Filesearch to populate the listbox with the name of
the files in the folder.
This worked fine in Excel 2003, but for some reason Excel 2007 spits it out
with an error message (can't remember what it is).

Basically, I need to populate a listbox with the files in a folder.
All help appreciated.
Libby x