How to use VBA to change file genre

Asked By gutierrez ryan 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.

• Status: Open
• Question Views: 1115
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Bowl Louise 0 points N/A #167394

How to use VBA to change file genre

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.

 

About Bowl Louise

Questions
0

Answers
101

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 01/21/2013
• Question Category: Visual basic