How to use VBA to change file genre
Asked By
0 points
N/A
Posted on - 12/25/2012
Hello Friends, I would like to know on How to use VBA to change file genre, Please provide sample coding or suggest the method.
Hello Friends, I would like to know on How to use VBA to change file genre, Please provide sample coding or suggest the method.
Hello
I will provide you with two functions. First function retrieve information you want, in your case genre and second one writes new information into your file.
Retrieve information:Â
Function GetProperty(PropertyName As String, PropertySet As PropertyLocation, _
Optional WhatWorkbook As Workbook) As Variant
Write information:
Function SetProperty(PropertyName As String, PropertySet As PropertyLocation, _
PropertyValue As Variant, Optional ContentLink As Boolean = False, _
Optional WhatWorkbook As Workbook) As Boolean
Change this according to your needs.
Regards.
Â