A bit late, but I just goto the folder in the command prompt and type
dir /b > list.txt
Then open list.txt in notepad and copy into excel
Hi,
Does anyone know of a small program that will export all file names within a folder and place them in an excel doc?
any help would be appriciated
PS, i thought there was something posted before the crash, but cant remember the name.
Gav
Look Here -> |
A bit late, but I just goto the folder in the command prompt and type
dir /b > list.txt
Then open list.txt in notepad and copy into excel
yeah thanks, i ended up using this in a batch file, made a shortcut to the bat file and put it in "send to" folder, now i just right click any folder ,select sendto and click the batch shortcut, it opens up notepad withh all the file names
--------------------------------------------------
dir %1 /-p /a:-d /b /o > "%temp%\file List"
notepad "%temp%\file List" erase "%temp%\file List"
--------------------------------------------------
That's even better, thanks mate.
Is there a way to remove the extension?
i dont think so, but someone else may correct this
Yeah, after you dump the filename into excel you do "TEXT TO COLUMNS" and use . as your delimiter.
Another way would be to use a formula like =left(len(a1)-4) in cell b1 of excel, assuming the extension is 3 digits preceded by a .
Thank YOU Moo for taking the trouble to join and to post your appreciation.
Good manners is always appreciated. I wish that there were more like you. Unfortunately politeness and respect are disappearing at an alarming rate.
Having said that, Welcome to Austech!
Now that you have joined, please consider looking in from time to time. Perhaps you will be able to help others also. The forums cover a vast range of topics.
I'm with Tristen, moo, what makes any forum great, is the contribution made by members such as yourself. I hope to see you here in future.
Bookmarks