View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Libby Libby is offline
external usenet poster
 
Posts: 151
Default Excel 2007 filesearch

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