Import Folder Names From Explorer to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

Please help me figure a way to import hundred
of folder names from Explorer into Excel without doing it individuall
(that's a lot of copy-paste!

Thanks
 
Please visit the Excel experts in the Excel newsgroup
news://msnews.microsoft.com/microsoft.public.excel

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User

Be Smart! Protect your PC!
http://www.microsoft.com/security/protect/

--------------------------------------------------------------------------------------


| Hi all,
|
| Please help me figure a way to import hundreds
| of folder names from Explorer into Excel without doing it individually
| (that's a lot of copy-paste!)
|
| Thanks
 
Bob said:
Hi all,

Please help me figure a way to import hundreds
of folder names from Explorer into Excel without doing it individually
(that's a lot of copy-paste!)

Thanks
Click to expand...

or hundreds of mp3 filenames... like I did.
Not a perfect solution but I used the command line (Win98)
directory statement

DIR /ad /s /on > C:/myfile.txt

this writes the attribute directory (/ad)names,
recursed into all subdirectories (/S)
in name order ( /on ) to a file ( > ) located wherever...
Open with notepad or whatever and clean up as needed

re-open cleaned-up file with Excel and import.
If you need to maintain structure make the file into a comma delimited
file

"find and replace" commas for backslash

programs,winamp
programs,winamp,plugins
programs,winamp,skins

instead of

programs\winamp
programs\winamp\plugins
programs\winamp\skins


then programs will be in col A
winamp will be in col B etc

OR search web for a little free utility DirPrint that does the same
thing from the point and click mode...
Hope this helps
 
Back
Top