Class VbaProjectReference
Contents
[
Hide
]VbaProjectReference class
Represents the reference of VBA project.
public class VbaProjectReference
Properties
Name | Description |
---|---|
ExtendedLibid { get; set; } | Gets and sets the extended Libid of the reference. |
Libid { get; set; } | Gets and sets the Libid of the reference. |
Name { get; set; } | Gets and sets the name of the reference. |
RelativeLibid { get; set; } | Gets and sets the referenced VBA project’s identifier with an relative path. |
Twiddledlibid { get; set; } | Gets and sets the twiddled Libid of the reference. |
Type { get; } | Gets the type of this reference. |
Methods
Name | Description |
---|---|
Copy(VbaProjectReference) |
Examples
[C#]
//Instantiating a Workbook object
Workbook workbook = new Workbook();
// Init VBA project.
VbaProject vbaProject = workbook.VbaProject;
// Add vba project reference
vbaProject.References.AddRegisteredReference("stdole", "*\\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\\Windows\\system32\\stdole2.tlb#OLE Automation");
//Saving the Excel file
workbook.Save("book1.xlsm");
[Visual Basic]
'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Init VBA project.
Dim vbaProject as VbaProject = workbook.VbaProject
'Add vba project reference
vbaProject.References.AddRegisteredReference("stdole", "*\\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\\Windows\\system32\\stdole2.tlb#OLE Automation")
'Saving the Excel file
workbook.Save("book1.xlsm")
See Also
- namespace Aspose.Cells.Vba
- assembly Aspose.Cells