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?
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?