+ Reply to Thread
Results 1 to 4 of 4

How to extract the time created from video files into excel sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    08-03-2014
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    2

    How to extract the time created from video files into excel sheet

    I have about 500 ASF files (video), usually I manually type time and date for each video clip in a Excel sheet, this is a very time demanding enterprise... Could this been done with some programming? I've never done VBA, but I hope that there are some tools ready to use.

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: How to extract the time created from video files into excel sheet

    sure can be done. Quick google session:

    http://www.mrexcel.com/forum/excel-q...lications.html

    code to follow soon
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: How to extract the time created from video files into excel sheet

    Sub test()
    
    Dim file As Variant
    Dim oFS As Object
    Dim strFilename As String, strPath As String
    Dim iCounter As Integer
    
    On Error Resume Next 'dunno why, but a pdf has thrown an error ;o
        
    Set oFS = CreateObject("Scripting.FileSystemObject")
    strPath = "C:\Users\Bishonen\Downloads\"
    
    file = Dir(strPath)
    While (file <> "")
        Range("A" & 1 + iCounter).Value = oFS.GetFile(strPath & file).DateCreated
        file = Dir
        iCounter = iCounter + 1
    Wend
    
    End Sub

  4. #4
    Registered User
    Join Date
    08-03-2014
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    2

    Re: How to extract the time created from video files into excel sheet

    Thanks! It worked
    Last edited by Kestrel78; 08-03-2014 at 11:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract specific data from a sheet created by a non-expert Excel user
    By gak67 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-18-2014, 12:00 AM
  2. Load multiple excel files into an excel sheet and extract data
    By Martijn79 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-03-2013, 06:08 PM
  3. Extract Pdf files embedded in an Excel Sheet
    By gururajendrak in forum Excel General
    Replies: 0
    Last Post: 07-20-2010, 03:32 AM
  4. [SOLVED] How to get Excel to open text files by the time created not name
    By khm6278 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2006, 11:35 AM
  5. Replies: 2
    Last Post: 07-29-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1