Hi, I want to build some kind of register over the photos/videos that I have used in Windows Movie Maker, that saves files in raw text format (extension .vlmp).

My general idea is to use Word/Access VBA to run through my VLMP files, and verify the file location. Suplementray - if the files was move to a diffrent harddisk/folder the program must "analyze" the HD, and build an access table containing all photo/video files.

That is the photo/video file-names are uniqe, but I had to move them from my pc to an external harddisk...

VLMP format, may look like this:
<MediaItem id="17" filePath="D:\Videos\Kamera\201406\201406A0\030620142102.mp4" arWidth="1280" arHeight="720" duration="28.639099999999999" songTitle="" songArtist="" songAlbum="" />

my program should then register the pathName "D:\Videos\Kamera\201406\201406A0\" and fileName: "030620142102.mp4"

.... when the pathsName\fileName does not exist, the program should simply suggest a new pathName and perhaps modify the VLMP file and save it with a new name.
Access/Word/FilePath?

Off the top of my head I assume that I need to use a mix of VBA functions, and I am quite familliar with programming (I have done a bit of VBA sample modifications).


What I need is some "expert direction" as to where to "start out":

  • Is this an Access application?
  • What VBA libaries do I need?
  • Where do I find sample code that runs through a text/file, or would you suggest I use Word-VBA commands?


Best regards
Per Olsen