Excell Question - importing external info

[zakbzalb]

Can somebody give me a solution for te following:
I have an open worksheet in Excell, I'd like to read the list of the files from some filedirectorium and to write it down in Excell worksheet in column A. (just the name of the files, ni size, date etc... ) ni (perhaps few hundreds of file names). In Old DOS we could list a files in TXT file with command DIR C:\ >FILENAME. Anything possible to do in Excell, (perhaps with VBA) to be convinient to user?
How can I do that?

 

[Smitty]

Welcome to the Board!

See john Walkenbach's tip for getting a list of file names.

It still involves a DOS prompt, but explains how to get it into Excel.

Hope that helps,

Smitty

 

[zakbzalb]

Thank you Smitty, you helped me, it can work, though no automatically from excell, but in 2 steps i can do the job.