Item
Contents
[
Hide
]VbaModuleCollection indexer (1 of 2)
Retrieves a VbaModule
object by index.
public VbaModule this[int index] { get; }
Parameter | Description |
---|---|
index | Zero-based index of the module to retrieve. |
Examples
Shows how to access a document’s VBA project information.
Document doc = new Document(MyDir + "VBA project.docm");
// A VBA project contains a collection of VBA modules.
VbaProject vbaProject = doc.VbaProject;
Console.WriteLine(vbaProject.IsSigned
? $"Project name: {vbaProject.Name} signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n"
: $"Project name: {vbaProject.Name} not signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n");
VbaModuleCollection vbaModules = doc.VbaProject.Modules;
Assert.AreEqual(vbaModules.Count(), 3);
foreach (VbaModule module in vbaModules)
Console.WriteLine($"Module name: {module.Name};\nModule code:\n{module.SourceCode}\n");
// Set new source code for VBA module. You can access VBA modules in the collection either by index or by name.
vbaModules[0].SourceCode = "Your VBA code...";
vbaModules["Module1"].SourceCode = "Your VBA code...";
// Remove a module from the collection.
vbaModules.Remove(vbaModules[2]);
See Also
- class VbaModule
- class VbaModuleCollection
- namespace Aspose.Words.Vba
- assembly Aspose.Words
VbaModuleCollection indexer (2 of 2)
Retrieves a VbaModule
object by name, or Null if not found.
public VbaModule this[string name] { get; }
Examples
Shows how to access a document’s VBA project information.
Document doc = new Document(MyDir + "VBA project.docm");
// A VBA project contains a collection of VBA modules.
VbaProject vbaProject = doc.VbaProject;
Console.WriteLine(vbaProject.IsSigned
? $"Project name: {vbaProject.Name} signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n"
: $"Project name: {vbaProject.Name} not signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n");
VbaModuleCollection vbaModules = doc.VbaProject.Modules;
Assert.AreEqual(vbaModules.Count(), 3);
foreach (VbaModule module in vbaModules)
Console.WriteLine($"Module name: {module.Name};\nModule code:\n{module.SourceCode}\n");
// Set new source code for VBA module. You can access VBA modules in the collection either by index or by name.
vbaModules[0].SourceCode = "Your VBA code...";
vbaModules["Module1"].SourceCode = "Your VBA code...";
// Remove a module from the collection.
vbaModules.Remove(vbaModules[2]);
See Also
- class VbaModule
- class VbaModuleCollection
- namespace Aspose.Words.Vba
- assembly Aspose.Words