Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Office help - "pasting" files

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Office help - "pasting" files

Old 06-13-06, 05:53 PM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Cusm's Avatar
 
Join Date: Jan 2000
Location: Moore, OK
Posts: 7,566
Received 0 Likes on 0 Posts
Office help - "pasting" files

I am ripping my cd collection and the database I had created is about 4 years out of date. Instead of retyping all of my cds into another Excel spreadsheet or Word document I thought I would try and be lazy, but I have not been able to figure out how to do what I want.

Is there a way to copy the names of all the files in a certain folder and then paste them into Word or Excel?
Old 06-13-06, 06:37 PM
  #2  
DVD Talk Hall of Fame
 
Join Date: Nov 1999
Location: Vermont
Posts: 9,775
Likes: 0
Received 0 Likes on 0 Posts
In DOS (aka the Command Prompt), enter:

dir [directory] /b

e.g., dir c:\mystuff /b

You can then copy and paste from there using the Mark option in the menu. You could also add a command to send this info to a file as follows:

dir [directory] /b > [filename.txt]

e.g., dir c:\mystuff /b > list.txt
Old 06-14-06, 05:47 PM
  #3  
DVD Talk Legend
 
Join Date: Jul 1999
Location: The L.A.
Posts: 18,122
Likes: 0
Received 0 Likes on 0 Posts
You can also use a program that will do it for you.

MediaMonkey will let you export your library to Excel (as well as html and others)
Old 06-14-06, 05:56 PM
  #4  
DVD Talk Legend
 
Join Date: Mar 2003
Location: Lyon Estates
Posts: 10,795
Likes: 0
Received 0 Likes on 0 Posts
wouldn't copying it and "paste special" - "values" work?
Old 06-14-06, 05:59 PM
  #5  
Moderator
 
Groucho's Avatar
 
Join Date: Mar 2000
Location: Salt Lake City, Utah
Posts: 70,875
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by dick_grayson
wouldn't copying it and "paste special" - "values" work?
When you try this, "Paste Special" is greyed out.
Old 06-15-06, 08:20 AM
  #6  
Member
 
Join Date: Apr 2006
Location: London, England
Posts: 156
Likes: 0
Received 0 Likes on 0 Posts
I've done something similar with a set of image archives I have on disk. The images are split into different directories. Whenever I open the spreadsheet it automatically examines the directories and lists the names in the spread sheet.

This is very easy to do in VBA if you've any programming skills. I've not got my code to hand but a quick search for "VBA DIR" should find various code fragments you could tailor as needed such as:

http://j-walk.com/ss/excel/tips/tip97.htm

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.