exporting a list of a folder's files

[Guest]

I recently downloaded a compilation of 1000+ ebooks. My desire is to create an excel file with hyperlinks to each book. The list of books that come with the compilation does not match up with the names of the files. I would like to create a text file based off of the actual file names, without cuting and pasting each one seperately. Is there a way to do this, either through a windows function or through a third party program? Thanks

 

[Opinicus]

I recently downloaded a compilation of 1000+ ebooks. My desire is to
create an excel file with hyperlinks to each book. The list of books
that come with the compilation does not match up with the names of
the files. I would like to create a text file based off of the
actual file names, without cuting and pasting each one seperately.
Is there a way to do this, either through a windows function or
through a third party program? Thanks

Open a DOS prompt in the folder and type dir /b > dir.txt

That will give you a plain-vanilla text file with just the file names and
nothing else. Copy that into the clipboard and then paste it into an Excel
worksheet.

 

[Gord Dibben]

Philip

You might consider downloading Tushar Mehta's Directory List Add-in for Excel.

Imports the list straight to Excel.

http://www.tushar-mehta.com/ scroll to "Directory List" on left-side menu.

Gord Dibben Excel MVP