Explore folder names into excel

  • Thread starter Thread starter tammy
  • Start date Start date
T

tammy

Hi,
I'm trying to make a spreadsheet of folders (just the name
of the folder) from explore of the start menu and copy it
into excel. I have hundreds of different folders. So I was
wanting to know if there was a quick way of doing this?
Tammy
 
I'm trying to make a spreadsheet of folders (just the name
of the folder) from explore of the start menu and copy it
into excel. I have hundreds of different folders. So I was
wanting to know if there was a quick way of doing this?
Click to expand...

Not sure if you mean your what's under your my documents folder or in the
start menu folder that's part of your profile. Here's for the My Documents
folder--

1. Start > Run > cmd
2. cd %homepath%
3. cd "my documents"
4. dir /ad /b /s >mydirs.txt
5. notepad mydirs.txt
or
5. open mydirs.txt in Excel

Tip: while at the command line check out the different options of the dir
command by typing dir /?
 
Back
Top