Use the Windows Start command followed by Run and type in CMD
Navigate to the folder of interest (do you rememeber DOS?)
Type DIRfilelist.txt
Close the RUN window, open XL
In XL FIle|Open and open filelist.txt
Use Data|Text to columns to tidy it up. Might be best to open file in
Notepad first to remove header info
Not exacly 'automatic' !
best wishes
Bernard

"Edwin Mashiringwani" wrote in message
...
Hi All,

I have a number of files in a folder.

What I would like to do is create an XLS file as follows

1. Files in folder a- apple.pdf, orange.pdf, peach.pdf,
tomato.pdf,

the XLS file I create automatically (based on files in the folder) would
be
like this

A1: apple.pdf
B1: orange.pdf
C1: peach.pdf
D1: tomato.pdf

Is this possible to do ?

thanks in advance

Edwin Mashiringwani