Explore folder names into excel

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
 
M

Mark Henri

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?

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 /?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top