VbaModuleCollection
Contents
[
Hide
]VbaModuleCollection class
Represents the list of VbaModule
Methods
| Name | Description |
|---|---|
| add(sheet) | Adds module for a worksheet. |
| add(type, name) | Adds module. |
| add() | Reserved for internal use. |
| addDesignerStorage(name, data) | |
| addUserForm(name, codes, designerStorage) | Inser user form into VBA Project. |
| clear() | |
| contains() | Reserved for internal use. |
| get(index) | Gets VbaModule in the list by the index. |
| get(name) | Gets VbaModule in the list by the name. |
| get() | Reserved for internal use. |
| getCount() | |
| getDesignerStorage() | Represents the data of Designer. We do not support to parse them. Just only for copying. |
| indexOf() | Reserved for internal use. |
| iterator() | |
| remove(sheet) | Removes module for a worksheet. |
| remove(name) | Remove the module by the name |
| removeAt() |
add(sheet)
Adds module for a worksheet.
| Parameter | Type | Description |
|---|---|---|
| sheet | Worksheet | The worksheet |
Returns: Number — Number
add(type, name)
Adds module.
| Parameter | Type | Description |
|---|---|---|
| type | Number | VbaModuleType |
| name | String | The name of module. |
Returns: Number — Number
add()
Reserved for internal use.
addDesignerStorage(name, data)
| Parameter | Type | Description |
|---|---|---|
| name | String | |
| data | Array of byte |
addUserForm(name, codes, designerStorage)
Inser user form into VBA Project.
| Parameter | Type | Description |
|---|---|---|
| name | String | The name of user form |
| codes | String | The codes for the user form |
| designerStorage | Array of byte | the designer setting about the user form |
Returns: Number — Number
clear()
contains()
Reserved for internal use.
get(index)
Gets VbaModule in the list by the index.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The index. |
Returns: VbaModule — VbaModule
get(name)
Gets VbaModule in the list by the name.
| Parameter | Type | Description |
|---|---|---|
| name | String | The name of module. |
Returns: VbaModule — VbaModule
get()
Reserved for internal use.
getCount()
getDesignerStorage()
Represents the data of Designer. We do not support to parse them. Just only for copying.
indexOf()
Reserved for internal use.
iterator()
remove(sheet)
Removes module for a worksheet.
| Parameter | Type | Description |
|---|---|---|
| sheet | Worksheet | The worksheet |
Returns: void — void
remove(name)
Remove the module by the name
| Parameter | Type | Description |
|---|---|---|
| name | String |