Macro Members

Function

Name Description
Activate Brings the macro to the front.
Close Closes the macro.
DebugExecute -
Execute Executes the macro.
ExecuteWithArgument Executes the macro. Pass any parameters encapsulated in variant.
Save Saves the macro.
SaveAs Saves the macro as the specified file string.

Return value: Boolean.

SaveToEnterprise -

Properties

Name Description
Application Returns the application associated with the macro. Return value: . This property is read only.
Code Returns or sets the macro code.

Return or assignment value: String.

Description Returns or sets the description of the macro.

Return or assignment value: String.

ExecutingInstruction Get the currently executing instruction. Macro must be running.

Return value: String.

This property is read only.

ExecutingLine Get the currently executing line number. Macro must be running.

Return value: Long.

This property is read only.

ExecutingProcName Get the currently executing procedure name. Macro must be running.

Return value: String.

This property is read only.

FullName Returns the fullname (including file path) of the macro.

Return value: String.

This property is read only.

Name Returns or sets the name of the macro. Return or assignment value: String.
Parent Returns the application associated with the macro.

Return value: . This property is read only.

Path Returns the file path of the macro.

Return value: String.

This property is read only.

Property Return or assignment value: Variant.
Run Runs, stops, or tells whether the macro is running or not.

Return or assignment value: Boolean.

Saved Returns or sets whether the latest changes in the document have been saved. Return or assignment value: Boolean.
Scripting Returns or sets the scripting language of the macro.

Return or assignment value: Integer.

Text Returns or sets the text within the macro. Return or assignment value: String.
Type Get the type of this macro. Return value: . This property is read only.
Visible Returns or sets the visibility of the macro. Return or assignment value: Boolean.
Window Returns the window of the macro.

Return value: . This property is read only.

WorkbookItem Returns the WorkbookItem interface if the object is in a Workbook.

Return value: . This property is read only.

Events

Name Description
Activate Called when the macro is brought to the top.
BeforeAddToWorkbook Called before macro is added to a workbook.
BeforeClose Called before the macro is closed.
BeforePrint Called before the macro is printed.
BeforeRightClick Called when an area in the macro has been right clicked.
BeforeSave Called before the macro is saved.
Begin Called when the macro is executed.
CodeChanged Called when the macro code has changed.
Deactivate Called when the macro loses the focus.
End Called when the macro finishes execution.
ErrorAlert Called when a syntax or runtime error occurs.
OnClose Called when the macro is closed.
Open Called when the macro is opened.
SelectionChanged Called when the selected item or text in the macro has changed.