How can I export to excel the directory listing on my HD? I have various home videos (over 100) and I want to know what is the total duration without having to enter each one manually. I have the directory so that it shows each video's duration in minutes & seconds and I want to export this to excel but haven't found a way as of yet.
Is there a program out there that can export this to excel? Thanks.
		
			+ Reply to Thread
			
		
		
		
			
	
	
				Results 1 to 2 of 2
			
		- 
	_____________________________
 Thank God For Jesus Christ!!!
- 
	Hello 
 
 He he Just solved this one! ... and did a search for "Excel" to see, if someone can use it: Just solved this one! ... and did a search for "Excel" to see, if someone can use it:
 
 It will scan your whole drive and list all Videos with Size, Duration, Audio, Subtitles, Compression Rate ... whatever you want, since the header will be read with MediaInfo.
 
 F5 will start the Video at a specific Scene or from beginning if you want. 3D will automatically start in Stereo Player, Shift-F5 open the Wikipedia-Page, or ... or ... or... everything to customize ... some Buttons ...
 
 Interested? ... so I will have a look, how to give you the necessary files.
 
 How are your VB-Skills?
 
 Regards,
 Bruno
 (from Switzerland so excuse my German notes in code an sheet...)
Similar Threads
- 
  encoded video duration different than vob durationBy fatcharlie in forum Video ConversionReplies: 9Last Post: 4th Dec 2011, 11:04
- 
  Help with an IF/THEN formula in EXCELBy Rudyard in forum ComputerReplies: 4Last Post: 13th Sep 2011, 02:53
- 
  Excel 07 vs Excel 03By jyeh74 in forum ComputerReplies: 4Last Post: 1st Sep 2011, 19:22
- 
  Excel help!By alintatoc in forum ComputerReplies: 11Last Post: 6th Dec 2009, 21:42
- 
  How to activate macro's in Excel 2007 with a spreadsheet from Excel 97By blinky88 in forum ComputerReplies: 3Last Post: 11th Feb 2009, 12:21


 
		
		 View Profile
				View Profile
			 View Forum Posts
				View Forum Posts
			 Private Message
				Private Message
			 
 
			
			

 Quote
 Quote