How to use VBA to change file genre

Asked By 0 points N/A Posted on -
qa-featured

Hello Friends, I would like to know on How to use VBA to change file genre, Please provide sample coding or suggest the method.

SHARE
Answered By 0 points N/A #167394

How to use VBA to change file genre

qa-featured

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.

 

Login/Register to Answer

Related Questions