Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WinExplorer info to Excel
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 "camera" which does this. Thank you for your time and attention -- Anne Murray |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
WinExplorer info to Excel
You can do it if you want to use "DOS" commands: Go to "START" - "ACCESSORIES" - "COMMAND PROMPT" 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 "STUFF" the files will be to the far right of the menu list. Right Click the MOUSE and then 'SELECT ALL' then hit the "ENTER KEY" 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:\or other drive prompt and know the file names - type CD\Directory Name, example for the Desktop it would be C:\CD\DESKTOP Then if there is a Sub Directory in DESKTOP (i.e Records) the command would be C:\CD\DESKTOP\Records -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=498058 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
WinExplorer info to Excel
Thank you very much.
-- Anne Murray "wjohnson" wrote: You can do it if you want to use "DOS" commands: Go to "START" - "ACCESSORIES" - "COMMAND PROMPT" 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 "STUFF" the files will be to the far right of the menu list. Right Click the MOUSE and then 'SELECT ALL' then hit the "ENTER KEY" 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:\or other drive prompt and know the file names - type CD\Directory Name, example for the Desktop it would be C:\CD\DESKTOP Then if there is a Sub Directory in DESKTOP (i.e Records) the command would be C:\CD\DESKTOP\Records -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=498058 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do i change info in all my cust cards in excel in one go | Excel Discussion (Misc queries) | |||
Can I link Contact info into an Excel doc? | Excel Worksheet Functions | |||
Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |