software

If I open My Computer (Windows 2000 Professional) in Details View, I can view
the contents of any given folder or drive, with columns for filename, size,
date created, date Modified, Author, etc. My question is, is there any way
to get this information into an Excel worksheet?

I have used another database explorer program (Invitrogen Vector NTI 10)
which has a button called quot;cameraquot; which does this.

Thank you for your time and attention
--
Anne Murray


You can do it if you want to use quot;DOSquot; commands:
Go to quot;STARTquot; - quot;ACCESSORIESquot; - quot;COMMAND PROMPTquot;
Then type C: - hit ENTER and you should be at the C: Directory
Then type DIR - hit ENTER and you should get a list of quot;STUFFquot; the
files will be to the far right of the menu list.
Right Click the MOUSE and then 'SELECT ALL' then hit the quot;ENTER KEYquot;
this should select ALL listed info. Go to your EXCEL Sheet and then
Paste. Do a SELECT ALL - and change the FONT to COURIER. Then Select
ALL of COLUMN A or whatever column you pasted the info into - then on
the EXCEL MENU Bar - Select DATA - TEXT TO COLUMNS and follow the
prompts.
To get more info about the DOS commands - after selecting the Command
Prompt - type HELP.
To Change Directories on C Drive - Once you at C:\gt;or other drive
prompt and know the file names - type CD\Directory Name, example for
the Desktop it would be C:\gt;CD\DESKTOP
Then if there is a Sub Directory in DESKTOP (i.e Records) the command
would be C:\gt;CD\DESKTOP\Records--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=498058Thank you very much.
--
Anne Murrayquot;wjohnsonquot; wrote:

gt;
gt; You can do it if you want to use quot;DOSquot; commands:
gt; Go to quot;STARTquot; - quot;ACCESSORIESquot; - quot;COMMAND PROMPTquot;
gt; Then type C: - hit ENTER and you should be at the C: Directory
gt; Then type DIR - hit ENTER and you should get a list of quot;STUFFquot; the
gt; files will be to the far right of the menu list.
gt; Right Click the MOUSE and then 'SELECT ALL' then hit the quot;ENTER KEYquot;
gt; this should select ALL listed info. Go to your EXCEL Sheet and then
gt; Paste. Do a SELECT ALL - and change the FONT to COURIER. Then Select
gt; ALL of COLUMN A or whatever column you pasted the info into - then on
gt; the EXCEL MENU Bar - Select DATA - TEXT TO COLUMNS and follow the
gt; prompts.
gt; To get more info about the DOS commands - after selecting the Command
gt; Prompt - type HELP.
gt; To Change Directories on C Drive - Once you at C:\gt;or other drive
gt; prompt and know the file names - type CD\Directory Name, example for
gt; the Desktop it would be C:\gt;CD\DESKTOP
gt; Then if there is a Sub Directory in DESKTOP (i.e Records) the command
gt; would be C:\gt;CD\DESKTOP\Records
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=498058
gt;
gt;