VbaModuleCollection

VbaModuleCollection class

Represents the list of VbaModule

class VbaModuleCollection;

Method	Description
get(number)	Gets VbaModule in the list by the index.
addDesignerStorage(string, number[])
getDesignerStorage(string)	Represents the data of Designer.
add(Worksheet)	Adds module for a worksheet.
add(VbaModuleType, string)	Adds module.
addUserForm(string, string, number[])	Inser user form into VBA Project.
remove(Worksheet)	Removes module for a worksheet.
remove(string)	Remove the module by the name
getCount()	Gets the number of elements contained in.

Gets VbaModule in the list by the index.

get(index: number) : VbaModule;

Parameters:

Parameter	Type	Description
index	number	The index.

Returns

VbaModule

addDesignerStorage(name: string, data: number[]) : void;

Parameters:

Parameter	Type	Description
name	string
data	number[]

Represents the data of Designer.

getDesignerStorage(name: string) : number[];

Parameters:

Parameter	Type	Description
name	string

Returns

number[]

Remarks

We do not support to parse them. Just only for copying.

Adds module for a worksheet.

add(sheet: Worksheet) : number;

Parameters:

Parameter	Type	Description
sheet	Worksheet	The worksheet

Adds module.

add(type: VbaModuleType, name: string) : number;

Parameters:

Parameter	Type	Description
type	VbaModuleType	The type of module.
name	string	The name of module.

Inser user form into VBA Project.

addUserForm(name: string, codes: string, designerStorage: number[]) : number;

Parameters:

Parameter	Type	Description
name	string	The name of user form
codes	string	The codes for the user form
designerStorage	number[]	the designer setting about the user form

Removes module for a worksheet.

remove(sheet: Worksheet) : void;

Parameters:

Parameter	Type	Description
sheet	Worksheet	The worksheet

Remove the module by the name

remove(name: string) : void;

Parameters:

Parameter	Type	Description
name	string

Gets the number of elements contained in.

getCount() : number;