Re: Filename list into Excel

Tricky! The Dir command in a command prompt will list your files with a date
& time, but by default this is the last modified date (I think). You can
direct the output to a file with

Dir drive:\path\*.*>c:\filenames.txt /on

The /on switch exports the data in alphabetical order, then use Excel's
data import facility (fixed width). You can also add the /tc switch to show
the creation date or the /tw switch to show the last written date.
Unfortunately it is not possible bybthis method to show both together.

One way round this would be to use one switch and import the data, then use
the other and import that starting on the same row, but at a different
column. As long as the /on switch is used, the filenames will be in the same
order in both output files. You can then delete the column with duplicate
data.

--
Ian
--
"Fred" <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E56395F5-9A4A-4565-AC3F-0AEECFD6A5E7@xxxxxxxxxxxxxxxx
> Hi,
>
> I would welcome help with the following problem:
>
> I need to generate a spread*** that contains the filename, date created
> and date modified (at least) for all files in a folder. I'm not
> interested
> in the content of theses files, I just need the file properties in a
> spread***.
>
> Any suggestions as to how to achieve this will be greatly appreciated.
>
> Regards,
> Fred


.