Modifying the metadata in VBA

[Harry Covair]

Hi the forum,

Is there a VBA function to change the metadata of (AVI) files, for example:author, subject, category)starting from an Excel spreadsheet

It is perhaps important to know that these properties, although visible, are not accessible via the properties dialog.


Thanks for any advice or solutions.


Harry

 

[shrivallabha]

I must admit that I have not used this but it looks like closer option for you to check:

http://support.microsoft.com/kb/224351

 

[Harry Covair]

Hi shrivallabha,

Thanks for answering my post.

I have carefully read the document referred by the hyperlink.

Without having downloaded the dll, I fear that it is only working for OLE files and AVI or MP4 are not OLE.. It is not mentioned that this dll is for Office 2010.

Finally, it poses problems in 64-bit environment (see http://www.codeproject.com/Questions/485175/windowsplus7plusdoesn-27tplussuppotplusDSOfile). I cannot compile a VBA application in 32 bits.


If I have the opportunity to test on a 32-bit Windows and Office PC, I'll let you know.


Regards

Harry

 

[SirJB7]

Hi, Harry Covair!

Didn't checked, but I'd give it a try:

http://stackoverflow.com/questions/7477269/using-vba-to-read-the-metadata-or-file-properties-of-files-in-a-sharepoint-doc-l

Regards!

 

[Harry Covair]

Hi Sir JB7,

Thanks for your answer.

The document in reference explains how to read the properties in a specific environment.

My goal is to modify the properties of an AVI file in a VBA procedure, apparently, it is not obvious.

Have a nice weekend.

Harry