Printing or Exporting Windows Explorer View

G

Guest

Is there a way to export a Windows Explorer View in csv format so that I can
import it into excel.

I have a very extensive set of folders that I need to analyze for archiving
purposes so need the folder name, size and last modified dates.
 
J

Jon Scott

Is there a way to export a Windows Explorer View in csv format so that I
can
import it into excel.
I have a very extensive set of folders that I need to analyze for
archiving
purposes so need the folder name, size and last modified dates.


Maybe use dir command?

Open command prompt
Change to the folder you want to list
Type "dir > files.txt"
Open files.txt in Notepad.exe, delete header and footer information, and all
directory entries so it only shows files, save it.
Open Excel, go to File --> Open, change Files of Type to Text Files
Browse to the files.txt file and select Open
Follow the onscreen instructions for fixed width data type, lines breaks,
etc...

Jon.
 
P

Paul Randall

You might try GROUPS.google.com and search in Microsoft's VBscript newsgroup
for solution, and maybe post there.

-Paul Randall
 

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