Importing Folder Names Into Excel (Hundreds at a time)

  • 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 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 into Excel without doing it individually
| (that's a lot of copy-paste!)
|
| Thanks
 
Greetings --

From the command prompt (Start > Run > Cmd.exe), simply change to
the desired directory and type "dir > filelist.txt" or "dir > lpt1,"
just as you used to do in DOS. Any of the switches for the DIR
command (type "dir /?") will work with this command, if you wish to
modify the output. You can then subsequently edit the resulting text
file using NotePad, WordPad, Word, etc.

Alternatively:

HOW TO Add a Print Directory Feature for Folders in Windows XP
http://support.microsoft.com/?kbid=321379


Bruce Chambers

--
Help us help you:



You can have peace. Or you can have freedom. Don't ever count on
having both at once. -- RAH
 
Back
Top