Re: How do I compile a file name list on excel

Hi Mostyn,

> is
> there a way of impoting the file names from my documents direct to word or
> excel?
>

In Excel:

Define this name (Insert, Name, define):

Name: FileList
RefersTo:
=FILES($B$1)

Now type your full path and wildcards in cell B1:

C:\My Documents\*.xls

Now enter this formula into e.g. cell A1 and drag down:

=INDEX(FileList,ROW())

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com