Per Olsen
06-12-2014, 01:40 PM
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
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