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