VbaModuleType

Inheritance: java.lang.Object

public class VbaModuleType

Specifies the type of a model in a VBA project.

Examples:

Shows how to create a VBA project using macros.


 Document doc = new Document();

 // Create a new VBA project.
 VbaProject project = new VbaProject();
 project.setName("Aspose.Project");
 doc.setVbaProject(project);

 // Create a new module and specify a macro source code.
 VbaModule module = new VbaModule();
 module.setName("Aspose.Module");
 module.setType(VbaModuleType.PROCEDURAL_MODULE);
 module.setSourceCode("New source code");

 // Add the module to the VBA project.
 doc.getVbaProject().getModules().add(module);

 doc.save(getArtifactsDir() + "VbaProject.CreateVBAMacros.docm");
 

Fields

FieldDescription
CLASS_MODULEA module that contains the definition for a new object.
DESIGNER_MODULEA VBA module that extends the methods and properties of an ActiveX control that has been registered with the project.
DOCUMENT_MODULEA type of VBA project item that specifies a module for embedded macros and programmatic access operations that are associated with a document.
PROCEDURAL_MODULEA collection of subroutines and functions.
length

Methods

MethodDescription
fromName(String vbaModuleTypeName)
getName(int vbaModuleType)
getValues()
toString(int vbaModuleType)

CLASS_MODULE

public static int CLASS_MODULE

A module that contains the definition for a new object. Each instance of a class creates a new object, and procedures that are defined in the module become properties and methods of the object.

DESIGNER_MODULE

public static int DESIGNER_MODULE

A VBA module that extends the methods and properties of an ActiveX control that has been registered with the project.

DOCUMENT_MODULE

public static int DOCUMENT_MODULE

A type of VBA project item that specifies a module for embedded macros and programmatic access operations that are associated with a document.

PROCEDURAL_MODULE

public static int PROCEDURAL_MODULE

A collection of subroutines and functions.

length

public static int length

fromName(String vbaModuleTypeName)

public static int fromName(String vbaModuleTypeName)

Parameters:

ParameterTypeDescription
vbaModuleTypeNamejava.lang.String

Returns: int

getName(int vbaModuleType)

public static String getName(int vbaModuleType)

Parameters:

ParameterTypeDescription
vbaModuleTypeint

Returns: java.lang.String

getValues()

public static int[] getValues()

Returns: int[]

toString(int vbaModuleType)

public static String toString(int vbaModuleType)

Parameters:

ParameterTypeDescription
vbaModuleTypeint

Returns: java.lang.String