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

Field	Description
CLASS_MODULE	A module that contains the definition for a new object.
DESIGNER_MODULE	A VBA module that extends the methods and properties of an ActiveX control that has been registered with the project.
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	A collection of subroutines and functions.
length

Methods

Method	Description
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:

Parameter	Type	Description
vbaModuleTypeName	java.lang.String

Returns: int

getName(int vbaModuleType)

public static String getName(int vbaModuleType)

Parameters:

Parameter	Type	Description
vbaModuleType	int

Returns: java.lang.String

getValues()

public static int[] getValues()

Returns: int[]

toString(int vbaModuleType)

public static String toString(int vbaModuleType)

Parameters:

Parameter	Type	Description
vbaModuleType	int

Returns: java.lang.String