Import filenames into spreadsheet

**mgilmore77** · 03-17-2007, 01:00 PM

So I have a folder with over 100 pdf files, and I have to create a spreadsheet with all those filenames...just the names of the files, no data from the actual files. I had to do this a long time ago (like a year ago), and I found an Excel Add-in that did it for me. I just selected the folder and it would import all the filenames for me.

Anyone know a way to do this? I can't seem to find that add-in. I really need this to save a lot of time on this project.

Thanks in advance for any help!!

**VBA Noob** · 03-17-2007, 01:13 PM

Hi,

This link may help

http://www.j-walk.com/ss/excel/tips/tip18.htm

VBA Noob

**mgilmore77** · 03-17-2007, 01:22 PM

Thanks so much for your reply. I am a pretty 'basic' level user, and I have no idea how to use macros or anything.

BUT........This link did reference the add-in I was speaking of!!! SO THANK YOU!!!

"One more method if you want to by-pass the *.TXT file and pull directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering and sorting once you have the data in Excel.
http://www.tushar-mehta.com/
scroll down to Add-ins>Directory Listing.
Download the ZIP file and un-zip to your Office\Library folder.

Import filenames into spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

Import filenames into spreadsheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions