View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default copy doument names from a file into excel

Like the names of files in a folder?

If yes, then I use this technique:

I open a command prompt:
Windows start button|Run
cmd
(in windows xp)
and hit enter.

Then I traverse to the drive and folder that contains the files.

I type:
dir c:\myList.txt

This creates a text file in the root drive of my C: drive (away from the folder
with the names).

Then I close that window.
Open excel and use File|Open to open that text file.

After I'm done, I can clean up that .txt file.



Lizndc wrote:

I'm trying to copy 171 document names only into an excel spread sheet so that
I can then talk about the status of each document I don't seem to be able to
copy this information and then paste it into excel
I've tried Ctrl shift ctrl C ctrl V and nothing happens I've tried the Copy
function from the drop down menu but the paste option doesn't appear in excel


--

Dave Peterson