Hi

There was a small typo in Jan Karel's formula to be entered in A1
=INDEX(FILES,ROW())
should have read
=INDEX(FILELIST,ROW())

In XL2007, to Insert the name Filelist, Formulas tabDefined Names
sectionDefine Name
--
Regards

Roger Govier


"KK" wrote in message
...
Jan

Thanks for the help, but I'm struggling to understand.

I cannot find the menu sequence Insert/name/define ! I suspect the
problem is that I have excel 2007 (sorry - I should have said so in my
original email)

Thanks again

KK

"Jan Karel Pieterse" wrote in message
...
Hi Kk,

I want to develop a spreadsheet (Excel) which will have all the
files in one
of my folders as on of its columns!

I have tried opening explorer , using copy & paste, but it doesn't
seem to
work

Can anybody help please ?

In B1, enter your path and file wildcard, e.g.

c:\my documents\*.xls

Then select Insert, name, define.

Type FileList in the name box and

=FILES($B$1)

in the RefersTo box and hit enter.

Now in cell A1 type :

=INDEX(FILES,ROW())

copy down.

Note: Excel 2000 crashes if you copy a cell with this formula to
another
worksheet.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com